Thread: Free for All: help me speed up my Access Database
View Single Post
  #9  
Old January 10th, 2007, 07:26 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
John Spencer
external usenet poster
  
Posts: 7,815
Default Free for All: help me speed up my Access Database
Quote from Tony Toews
The three most common performance problems in Access 2000 a
- 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 URLs for a more complete discussion.

http://www.granite.ab.ca/access/performancefaq.htm

http://support.microsoft.com/?id=209126

Also
How to speed up slow queries
http://support.microsoft.com/kb/209126/en-us
Entitled: Information about query performance in an Access database

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Anthony" wrote in message
...
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?