News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, December 21, 2006

Access 2007 compact bug

Several people already reported in newsgroups, that when they compact Access 2007 database – Access 2007 shows a message, that database will be saved as MDB and then it gone. Completely! Don’t know if this is a real bug, but Access 2007 users should be aware of this misbehavior. While we get some patch or workaround for this – I suggest to make a copy of database before compacting it, like previous version of Jet did, and if compact fails – then you have a backup.

If you get this problem – try to look at Temp folder, perhaps something left there...


Anonymous Anonymous said...

I totally agree with you. I have previously experienced the same problem and trust me I was not pleased.
I own a shop which supplies leather handbags. I had to create a database which had all my customers data recorded as well as product details.
I created a database using Access 2007. I was familiar with using Microsoft Access as I have previously been using Access 2002 to store my product details.
I was continuously updating and changing details using Access 2007 on my database and found that while I saved the database the file size kept on increasing which was taking up a lot of space on my hard disk. I was confused as to why this was occurring because even though some of the changes I made involved me deleting certain data I still found the database file size did not reduce and at times increased.

The solution that was written on Microsoft Access Help feature was I should “Compact and Repair” the file.
I followed these instructions after I had updated my database with the latest data. Once the database was compacted a message popped up saying it will be saved as a MDB file!
As I had not used this feature before I thought this was normal, so I continued and when I came to open the database, I discovered that the file was nowhere to be found on my computer.

This had a major effect on my business as this database held vital information. Although I had a back up copy, this not had been updated hence I had to spend time going through that copy to update it, this was waste of my time!

If this is a bug, then I do clearly recommend that Microsoft should create a patch or an update to solve this problem. This can affect other people who also Access 2007. It has made unsure about using unfamiliar tools on Access.

9:35 PM  
Blogger Alex Dybenko said...

Thanks for your story, Dray!

9:13 AM  

Post a Comment

<< Home