KB article 950812: Compact and repair might delete your database (Access 2007)
KB article 950812 provide more information about a scenario where some people have reported that a compact and repair deletes their database. You can’t download the fix directly but can get it by calling CSS. This fix will be included in SP2 when that ships (I don’t have an ETA). Here is the most relevant part of the article:
In Office Access 2007, when you try to compact an .accdb database, you may receive the following error message:
Microsoft Office Access can't delete database name.accdb after compacting it. The compacted database has been named Database.mdb.
If you compact a database using the same name, Microsoft Access creates a new compacted database and then deletes the original database. In this case, however, the original database wasn't deleted because it is read-only.
If you can, remove the read-only status, delete the original database, and then rename the new database using the original name.
If you can't remove the read-only status, inform your workgroup administrator.
Additionally, after you click OK, you receive the following error message:
Could not find file 'database name.accdb'
Then, the original .accdb database and the temp-compacted Databasex.mdb database are removed unexpectedly.
