View Single Post
  #30  
Old January 10th, 2007, 11:41 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default Free for All: help me speed up my Access Database

To add to John's comments, perhaps you will find this document helpful:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/mu...lications.html

Several of the ideas included are equally applicable for a single-user
database.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"John Spencer" wrote:

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?