Compacting Error Message Upon Opening File

[bigjohn]

I'm running ACCESS 2007 in a Windows XP Home Edition environment. I got the
following error message when opening an ACCESS 2007 (.accdb) database:
"Microsoft Office can't delete Club.accdb after compacting it. The
compacted database has been named Database.mdb." There are more messages in
the dialog box, but this is the gist of my problem.

I could not find the file Database.mdb. My original file (Club.accdb) was
deleted. Fortunately I had a backup of the original file. This has happened
more than once with different ACCESS 2007 files.

What is puzzling to me is that a compacting operation is executed by ACCESS
2007 upon opening a file. Additionally, why would the compacted database be
assigned an .mdb file extension? Like I say, this has happened more than
once.

Any thoughts on what is happening here?

 

[Tom Wickerath]

Hi John,

Have you installed Office 2007 Service Pack 1 yet?
Also, see the Mar 6 '08 hotfix and the Apr 16 '08 hotfix, as shown on Access
MVP Allen Browne's listing found here:

http://allenbrowne.com/Access2007.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________


I'm running ACCESS 2007 in a Windows XP Home Edition environment. I got the
following error message when opening an ACCESS 2007 (.accdb) database:
"Microsoft Office can't delete Club.accdb after compacting it. The
compacted database has been named Database.mdb." There are more messages in
the dialog box, but this is the gist of my problem.

I could not find the file Database.mdb. My original file (Club.accdb) was
deleted. Fortunately I had a backup of the original file. This has
happened
more than once with different ACCESS 2007 files.

What is puzzling to me is that a compacting operation is executed by ACCESS
2007 upon opening a file. Additionally, why would the compacted database be
assigned an .mdb file extension? Like I say, this has happened more than
once.

Any thoughts on what is happening here?

 

[bigjohn]

Hi Tom,

Thanks for the feedback. It was very helpful. I am running SP1. The Apr 16
'08 Hotfix refers to my specific problem. Since the problem is known, I
think I will wait for SP2.

 

[MOHSE ELGHANDOR]

Hi Tom,

Thanks for the feedback. It was very helpful. I am running SP1. The Apr
16
'08 Hotfix refers to my specific problem. Since the problem is known, I
think I will wait for SP2.