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?