DAO Reocrdset

[smith9891]

Hi,
I have a database where I want to run a query and pass through the records appending field data them to class module variables. This works fine but seems quite slow (there is a lot of financial data). The question is what is the absolute fastest way to open a recordset? At the moment I am using dbs.openrecordset(querySqls, , dbforwardonly). Also I am getting a few 3043 (unrecognizedformat) & 3045 (already in use) errors when I am running a copy of the db at the same time as its running. Any thoughts on this?

Cheers

 

[HiTechCoach]

There is not a lot os ways to open a recordset. One thing that does effect the speed is the select statement and how much data it returns.

Have you stepped through your code to see if there really is a very long delay opening the recordset?

 

[boblarson]

At the moment I am using dbs.openrecordset(querySqls, , dbforwardonly). Also I am getting a few 3043 (unrecognizedformat) & 3045 (already in use) errors when I am running a copy of the db at the same time as its running. Any thoughts on this?

What are you assigning to dbs?

 

[smith9891]

Thanks for replies

dbs is currentdb
The sql is a quick as I can make it - its got indexes where required. I guess the bit I am stuck on is the options when opening a recordset and the effect they have on the data (locking etc) I know I only need dbForwardonly but what effect do the types have (the second option after the sql) eg snapshot? I am think that one of these may reduce my number of 3043 & 3045 errors.

Cheers