Access Has Renamed My MDB but to what?

[gray]

Hi

Access 2007

Just when you think you've seen it all....

I was working on a Form which would not open.. in fact it crashed Access. During the crash/recovery it created the usual backup MDB .... so

Working copy = My_Database_v010.mdb
Auto backed up copy = My_Database_v010_Backup.mdb

30 mins later I (whilst still having problem with a Form) decided to do a Compact and Repair on my working copy.

I must have done this 1000 times before but, lo, something new happens!. During the Compact and Repair process, Access prompted me to say it could not complete the Compact and Repair and that it was renaming the mdb file (maybe this was because a "My_Database_v010_Backup.mdb" was already there??).

The $64,000 question is what the hell has it renamed it to? And in which directory?.

I have scanned my harddrive for *.mdb (including hidden files and system directories)... sorted on name/folder/date and can't identify the renamed database??

I suspect it has done this using a nomenclature standard of somesort... "blah_blah_Compacted" or whatever. It may well have even removed the .mdb suffix. Anyone know what that stahdard is please? Or is there an Access log I can inspect?

I have plenty of backup files but the youngest is at least 30 mins out of date... 30mins as we all know is a lifetime in IT !!

Thanks

 

[gemma-the-husky]

it will either be in the active folder, or possibly in the default folder for new databases,

you ought to keep an extra untouched copy of the latest version of all your databases, just in case anything happens. I keep a copy of every version of stuff I produce.

 

[gray]

Hi

Looked in both of those and the MSAccess.exe folder but there's nothing obvious ... I thought it might be recorded in the recent Dbs list... but no... that was too easy....

I version control all my DBs ... actually the one in question is version 410 would you believe Downside is I've hundreds of them...

 

[gemma-the-husky]

it looks like it got deleted then, which is abnormal - hopefully you can use your last good version.

 

[gray]

Oh-Oh.... just found this...

http://support.microsoft.com/?kbid=950812

I like the way it casually mentions:-

Then, the original .accdb database and the temp-compacted Databasex.mdb database are removed unexpectedly.

It's not in the re-cycle bin either so short of taking my drive out and scanning it for lost files.... looks like I've got to remember every line I've changed since the last backup...

I wonder where MS developers were trained? The circus maybe?