Closing Inefficiencies

[BCullenward]

It takes several minutes to close down my access database, it is not all that large (around 4-6 megs when compacted). Does Access go through and run all the queries prior to shutting down? If so is there a way to prevent this? (it has a SQL Server 2k backend) and the largest table that is used has less than 300k records

 

[grande]

Try this:

Tools --> Options --> General (tab)

Uncheck the three boxes under Name AutoCorrect.

That should speed up your runtime.

-------------------------
Just call me Captain Awesome.