In the Access 97 help files, I found some info on "greatly enhancing 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 (back end?) and link the table in the main database (front end?). Then use the OpenRecordset method to open the linked table." I can't find any info on HOW to use the OpenRecordset method to do this. Any help? Thanks!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.