PDA

View Full Version : Solved: Use Excel to force Access to compact & repair database



lifeson
11-18-2008, 08:23 AM
Is there a way I can use excel to use the compact and repair database option from the Tools>Database Utilities>Compact and Repair Database menu within access? :dunno

Kenneth Hobs
11-18-2008, 09:14 AM
This seems to work.
http://www.visualbasic.happycodings.com/Database_SQL_Stuff/code7.html

lifeson
11-19-2008, 01:18 AM
This seems to work.
http://www.visualbasic.happycodings.com/Database_SQL_Stuff/code7.html

Thanks Kenneth
I'll give that a go.

Some other good snippets on that site as well :friends: