How do I automate repair on close?

J

Jeff Boyce

More recent versions of Access have a Compact & Repair option on close --
which version are you using?

--
Good luck

Jeff Boyce
<Access MVP>

DMW said:
The database tables compact at night but I want the database to repair as
Click to expand...
well
 
D

Douglas J. Steele

Just to expand on Jeff's post, if you are using, say, Access 97, where
Compact and Repair are two separate options, you should never repair unless
Access tells you to. You can actually corrupt the database repairing
unnecessarily.
 

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
Access error 3059 0
How can I install Publisher in 365 Enterprise? 1
I can create Publisher documents, but I can not open / read them. 0
"Compile error in table level validation expression " after format 0
Timed Compact and Repair 2
Compact and Repair 1
Compact and Repair database 3

Top