Compacting Databases

G

Guest

Hi,

I have about 5 databases which I would like to compact and repair every
morning.

I wanted to do this by opening a 6th database, which would then open, and
compact and repair each of the other 5 databases.

Is there a simple string line of code which will open another database and
force a compact and repair, then close that database.

Version: Access 2002

Cheers

Neil
 

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

Compacting Backend Access Databases 6
automatically repair and compact databases without user interactio 1
Reserved error -1517 in fields 1
Linked table problem 1
Compacting 3
Cant open database. Error: "could not find the object 'databases' 1
Compact & Repair Code - File Permissions question 2
Compacting Access database 2

Top