Hi,
I would like an Excel Macro to be able to compact and repair a database called "Test.mdb" which is on my desktop.
I will run this macro when the database is closed, as i know you cannot compact a database when it is open.
I would like the new version of the Test Database to be named as "Test.mdb" too.
Hope someone can help.
Thank You
Bookmarks