General Database Maintenance Code

[Guest]

I thought I read or heard that there is some basic code every access database
should contain for maintenance reasons.....like an auto compact and
repair....I'm just curious if this is the consensus out there and if so, what
would you suggest I add to my database. Thanks for the help..

 

[Allen Browne]

It's best if you compact from outside the database.

Create a shortcut (on the Windows desktop, or in the Start menu), that has
something like this as its Target:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /compact
"C:\MyFolder\MyFile.mdb"

If the database is split, it's the back end file that needs compacting.