Hi Is it possible to compact and repair an external access 200 database via code? Thanks Regards
J John Mar 25, 2008 #1 Hi Is it possible to compact and repair an external access 200 database via code? Thanks Regards
D Daniel Pineault Mar 25, 2008 #2 Take a look at http://www.rogersaccesslibrary.com/TableOfContents3.asp#C there are a couple of sample databases that cover this subject (CompactBackEndDB.mdb ( expert ), CompactDatabase.mdb ( expert ) ) Also, here is another link that provides one solutio http://forums.devarticles.com/microsoft-access-development-49/compact-database-via-vba-24958.html -- Hope this helps, Daniel Pineault For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php If this post was helpful, please rate it by using the vote buttons.
Take a look at http://www.rogersaccesslibrary.com/TableOfContents3.asp#C there are a couple of sample databases that cover this subject (CompactBackEndDB.mdb ( expert ), CompactDatabase.mdb ( expert ) ) Also, here is another link that provides one solutio http://forums.devarticles.com/microsoft-access-development-49/compact-database-via-vba-24958.html -- Hope this helps, Daniel Pineault For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php If this post was helpful, please rate it by using the vote buttons.
