Results 1 to 2 of 2
  1. #1
    Seek2find is offline Novice
    Windows XP Access 2000
    Join Date
    Nov 2010
    Posts
    1

    Improving performance of linked table to other Access databases

    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!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Maybe this description of a Persistant Connection will be helpful.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Converting/Upsizing Linked Databases
    By Chaz88 in forum Import/Export Data
    Replies: 2
    Last Post: 08-11-2010, 06:46 PM
  2. Need help linking access databases
    By AlphaNumeric in forum Access
    Replies: 2
    Last Post: 05-18-2010, 04:08 PM
  3. Replies: 3
    Last Post: 01-21-2010, 08:10 PM
  4. Performance Issues with Replica databases
    By accessgenie in forum Access
    Replies: 1
    Last Post: 12-05-2009, 10:03 AM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums