Compact Error File Location

Hello and Thank you,

I have my Access 2007 set to automatically compact and repair at exit. The
last time I did, I got an error message saying there was an issue and it was
changing the name and location of the compacted database.

I can not find this repaired database and my original is gone now too.

Any ideas where I might find it?

Thanks,

Mark D. Meyer

OUCH! Mark, I think you have been bitten by one of the worst bugs in A2007.

Microsoft released a hotfix for this back in April 16:
http://support.microsoft.com/?kbid=950812
But unless you know about the problem, and requested the hotfix, you
probably have lost the database.

Other than the kb, what I know about the bug and how to avoid it is listed
below the table of bugs he
http://allenbrowne.com/Access2007.html#Bugs
i.e. just above the 'Configuration' section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mark D. Meyer" wrote in message
...
Hello and Thank you,

I have my Access 2007 set to automatically compact and repair at exit. The
last time I did, I got an error message saying there was an issue and it
was
changing the name and location of the compacted database.

I can not find this repaired database and my original is gone now too.

Any ideas where I might find it?

Thanks,

Mark D. Meyer

OUCH! Mark, I think you have been bitten by one of the worst bugs in
Access.

Maybe if you had read my reccomendations and moved to SQL Server--
then maybe your database wouldn't be _GONE_.

Microsoft released a hotfix for Jet in the fall of 2000
ACCESS DATA PROJECTS









On Dec 15, 5:56*pm, "Allen Browne" wrote:
OUCH! Mark, I think you have been bitten by one of the worst bugs in A2007.

Microsoft released a hotfix for this back in April 16:
* *http://support.microsoft.com/?kbid=950812
But unless you know about the problem, and requested the hotfix, you
probably have lost the database.

Other than the kb, what I know about the bug and how to avoid it is listed
below the table of bugs he
* *http://allenbrowne.com/Access2007.html#Bugs
i.e. just above the 'Configuration' section.

--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mark D. Meyer" wrote in ...

Hello and Thank you,

I have my Access 2007 set to automatically compact and repair at exit. The
last time I did, I got an error message saying there was an issue and it
was
changing the name and location of the compacted database.

I can not find this repaired database and my original is gone now too.

Any ideas where I might find it?

Thanks,

Mark D. Meyer