Hi I want to repair several databases through VBA codes. Is there a way I can pass the database file, and repair it? Thanks
Hi I want to repair several databases through VBA codes. Is there a way I can pass the database file, and repair it? Thanks
there is a COMPACTREPAIR action in the database library
Can you be more specific? How do I call it through code? Thanks
try something like:Code:
dim db as dao.database
set db = currentdb
db.compactrepair
There is no command like that. Anyone able to help me out here, with the actual code?
Thanks. It works fine for me in Access 2003. However, just found out the client I'm doing this for has Access 2000. And of course, application.compactrepair doesn't work from 2000! Do you know what the code was back then? There's always something!