Hi since migrating my application from dao to ADO I am experiencing slow repsonses accessing the catalog object. In DAO I used query definations.
The reason I am using the catalog is to access quieries in an access 2000 database. There are probably about 100 queries most of which have parameters.
The main delay seems to be with the opening of the catalog. I know I could change this so that the catalog is opened at the begining of the application but what would happen if some one crashed out.
Also one of the other problems I am having is that I have to put a delay into the program otherwise no data is returned.
Dim conn As ADODB.Connection
Set cat = New ADOX.Catalog
'set the catalog the current connection
cat.ActiveConnection = conn
'set the command to the query name
Set cmd = cat.Procedures("dp_Appoints_Qry").Command 'Killer SQL that has UNION...
'give the parameters
cmd.Parameters("AP CODE") = (Entity.code)
Set ApptRS = New ADODB.Recordset