Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Tables Open Slowly in Access 2003

Discussion in 'Information Technology' started by Roger, Jul 28, 2006.

  1. Roger

    Roger
    Expand Collapse
    Guest

    I have an Access 97 Database that was converted to Access 2003. It contains
    numerous tables that are linked over a network. Linked tables open slowly
    which is expected due to network speed however local tables seem to take
    sometimes two to three minutes to open. However if you open the Table via a
    query it will open immediately. This did not happen in Access97.
     
  2. Loading...

    Similar Threads Forum Date
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Cold weather damages sugarcane, vegetables in Punjab (New Kerala) Breaking News Feb 1, 2008

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    There are several things to address here, including Name AutoCorrect and
    SubdatasheetName

    Tony Toews has a good list in the Access Performance FAQ at:
    http://www.granite.ab.ca/access/performancefaq.htm

    For other issues you may need to be aware of, see:
    Converting from Access 97 to 2000 and later
    at:
    http://allenbrowne.com/ser-48.html
    The article discusses setup issues, conversion issues, and usability issues.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Roger" <Roger@discussions.microsoft.com> wrote in message
    news:5663BA9D-81CE-450B-BB56-7E727485FEB6@microsoft.com...
    >I have an Access 97 Database that was converted to Access 2003. It
    >contains
    > numerous tables that are linked over a network. Linked tables open slowly
    > which is expected due to network speed however local tables seem to take
    > sometimes two to three minutes to open. However if you open the Table
    > via a
    > query it will open immediately. This did not happen in Access97.
     

Share This Page