Compact and repair

C

Chad

Is there a way to compact and repair a database through
VBA? If so can someone please let me know?

Thanks,
Chad
 
C

Chad

Thanks,
That helped a lot. Mentioned in your post that you are
able to compact and repair other databases through code
assuming they are closed. Can you give me an idea of how
to do this?

Thanks,
Chad
 
N

Nikos Yannacopoulos

Chad,

In the same newsgroup there is a posting by Kcomer, titled "Compacting DBs",
dated 12/01/04 12:25. See my reply to that one.

Regards,
Nikos
 

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

Access error 3059 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
"Compile error in table level validation expression " after format 0
compact and repair 3
disk or network error 3
Error on Compact and Repair 4
Password HELP! 2
Error 7846 Can't compact and repair current database 2

Top