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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.