Design View SLOW

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large database newly converted to Access 2000. Some queries take
over 45 seconds to open in DESIGN view (not to run query...just to VIEW the
design). Is there some option that can be changed?
 
Compile, Save, Compact, Repair to start. Import all objects to a new mdb if
needed. That should eliminate all the possiblities for corruption.
 
In addition,
Quote from Tony Toews

The three most common performance problems in Access 2000 are:
- LDB locking which a persistent recordset connection fixes
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off
(Tools: Options: General Uncheck all name AutoCorrect features)
Other reasons are
- New format of Access 2000 MDB
- Place backend MDB on the root of the network share rather than several
folders down
- Shorten the name of the backend MDB
- Miscellaneous Performance Suggestions
End quote

Check out the following URL for a more complete discussion.

http://www.granite.ab.ca/access/a2kslow.htm
 
This seems to have helped. Thank you.

[MVP] S.Clark said:
Compile, Save, Compact, Repair to start. Import all objects to a new mdb if
needed. That should eliminate all the possiblities for corruption.
Click to expand...
 
Back
Top