Optimizing Performance w/ Linked Tables

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Having problems with linked tables over a network...
something that took 3-4 seconds with tables built into the
database is taking 20 minutes with linked tables.

I found this in Access 97 help.

"You can greatly enhance performance when opening the main
database and opening tables and forms, by forcing the
linked database to remain open. To do this, create an
empty table in the linked database and link the table in
the main database. Then use the OpenRecordset method to
open the linked table. This prevents the Microsoft Jet
database engine from repeatedly opening and closing the
linked database and creating and deleting the
associated .ldb file."

Can anyone be more specific as to how to go about this?

Thanks.
 
A simple way is to create a form that is bound to that linked empty table.
On startup open this form hidden and keep it open.
 
Back
Top