 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2005Backup then Compact
Hello, Is there any way to backup the open db before the "Compact on close" runs? I want a backup of my db in case compact corrupts it. I'm using Access 2002. Thanks! Theresa Access does this automatically - Raoul > Hello, > Is there any way to backup the open db before the "Compact on close" [quoted text clipped - 3 lines] > Thanks! > Theresa Where is the backup saved? I don't see a copy of the pre-compacted database in the same folder. Or are you saying that if the database is corrupted during the compact, it will not write over the pre-compacted version? Theresa Yep, Access compacts your current database into another file. When this was succesfull it will get rid of the old version and rename the new file. - Raoul > Where is the backup saved? I don't see a copy of the pre-compacted > database in the same folder. Or are you saying that if the database is > corrupted during the compact, it will not write over the pre-compacted > version? > > Theresa |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.