Access 2K Compact Database Code

[Tanya Addison]

Can anyone help me with some code so that I can automate the task of compacting a database. It will always be the current database
Thanks!

 

[Norie]

In options on the Tools menu there is an option Compact on save I beleive.

 

[Joe4]

Under Tools | Options | General,
there is an option to "Compact on Close".
This will compact the database every time you close it.

 

[mdmilner]

Above are the easy methods.
Here's a couple links on the same topic including code.

I recommend you read all of them - there are some problems with doing this purely from code.

http://www.mvps.org/access/general/gen0041.htm
http://www.mvps.org/access/bugs/bugs0045.htm
http://www.mvps.org/access/general/gen0013.htm

Mike

 

[Tanya Addison]

Thanks For the advice sorry for being so stupid!