I have a master database with linked tables to 3 other source databases. The performance is super slow. What can I do?
I found the following on the MS website. But what I can't seem to link an empty table in my master db to the source dbs. So what the below really mean?
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 from creating and deleting the associated .ldb file.
http://office.microsoft.com/en-us/ac...005187453.aspx
Thanks!