 |
Export DAO databases to any ISAM format
|
| Total Hit (3100) |
Everyone tells you how to import, but even MS-VB techs start coughing when you ask how to export with DAO! In fact, their own documentation clearly states that it can not be done (see the note on page 314 of Jet Database Engine Programmer's Guide's "Creating an External Table").
To that statemen
....Read More |
Rating
 |
|
|
|
|
|
Get the list of ODBC drivers
|
| Total Hit (4294) |
The ODBCTOOL.DLL library contains three functions that make it easier to manage DSNs. To run the following code you must add a reference to the "ODBC Driver & Data Source Name Functions" library to your References dialog box. If you don't find this library listed in the References list, use the Star
....Read More |
Rating
 |
|
|
|
Read and write File ODBC data sources
|
| Total Hit (4377) |
A file DSN is nothing but a text file that contains all the parameters for an ODBC connection. To prove this, just go to the default directory that holds all File DSNs (this is the \Program Files\Common Files\ODBC\Data Sources directory on Windows's boot drive) and load any .dsn file into a text edi
....Read More |
Rating
 |
|
|
|
|
|
Listing all available SQL Server
|
| Total Hit (2242) |
Thanks to the SQL-DMO object model, it's very easy to list all the available SQL Server 7.0 installations. For example, this code loads all the SQL Servers registered on the local machine into a ComboBox control:
«Code LangId=1»
' NOTE: this code assumes that you've added a reference to the
'
....Read More |
| Rating
|
|
|
|
Manage the SQL Server date format with SQL DMO
|
| Total Hit (3158) |
If you haven't localized SQL Server for your language, the default date format is the American one: DD/MM/YY. You may need to display a date in different formats, and you can solve this problem with the help of SQL DMO. A possible solution is using the T-SQL CONVERT() function to show the date with
....Read More |
| Rating
|
|
|
|
|
|
Compact and Repair Access MDB.
|
| Total Hit (2953) |
Following code requires Microsoft DAO 3.6 reference.
To add this reference goto Project->Reference
example:
«Code LangId=1»
Call DBCompact("OLt.mdb", "tmpOLT.mdb", , , ";pwd=mypwd")
«/Code»
|
| Rating
|
|
|
|
FillFlexGrid - Routine to fill flexgrid from ADO recordset
|
| Total Hit (3679) |
The following routine takes 2 arguments, ADO recordset and flexgrid which you want to fill.
«code LangId=1»
Sub FillFlexgrid(rst As ADODB.Recordset, msfGrid As MSFlexGrid)
Dim cln As Field
With msfGrid
.Rows = 2
.Cols = rst.Fields.Count
'get the number of gri
....Read More |
| Rating
|
|
|
|
Optimize Parametrized Queries With ADO Objects
|
| Total Hit (3141) |
When you write Insert statements, it can be difficult to accommodate the possible values end users might enter into a textbox. The most common task is replacing single quotes with double quotes. However, parameterized queries provide two benefits: You do not have to parse data entered by users—excep
....Read More |
| Rating
|
|
|
|
How To Use the ADO SHAPE Command
|
| Total Hit (3338) |
This article describes the ADO SHAPE command syntax for producing hierarchical recordsets, and explains how to traverse hierarchical recordsets. VBA sample code is also provided.
|
| Rating
|
|