ADO-PLEASE HELP!!!

[paddlefoot]

I have tried everything....asked everyone....read everything....
and racked my brains for hours upon hours, and yet, thier seems
to be no explination for the problem I am having.

The problem is very simple to explain:

It takes an unfeasable amount of time open a recordset with
ADO. I have an access table, about 1.5 meg in size. When
i open it with ADO (i.e. rs.open) it takes about 15-20 seconds
to open. This is on a local machine (no network). When i open
the table in MS-Access, it opens almost instantly. I have tried
playing with the page size, page count, and cache variables. Decreasing the amount of pages used to store the table in ram
has absolutley no affect on the time to open the table. If anyone
has any input on this matter, PLEASE let me know.


Your help is greatly appreciatted,


paddlefoot

[Forest Dragon]

Is your table linked to the database? If so, can you import it instead of linking it? Then it will take much less time to open it in VB.

Hope that will help you!