Can you Automate Compact & Repair in Access 97

S

S Jackson

I want to put in a Public Function in my database that will automatically
compact and repair a Access 97 database.

TIA
S. Jackson
 
B

Bob Finster

Got to the menu for Tools...Options....General Tab. Check
the "Compact on Close Box" in the lower left.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How can I install Publisher in 365 Enterprise? 1
Keeping to ms office 97 pro 0
unanble to compact dbs 2
Compact and Repair & Backup Database 12
Error-17099 SMTP Relay Error Problem Entourage 2004 0
Compact and Repair Database? 4
Compact back-end database 1

Top