tag:blogger.com,1999:blog-7176045.post116670018102117946..comments2008-02-26T09:13:11.651+03:00Alex Dybenkohttp://www.blogger.com/profile/16954512620659022712noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7176045.post-87227390816003491052008-02-26T09:13:00.000+03:002008-02-26T09:13:00.000+03:002008-02-26T09:13:00.000+03:00Thanks for your story, Dray!Alex Dybenkohttp://www.blogger.com/profile/16954512620659022712noreply@blogger.comtag:blogger.com,1999:blog-7176045.post-23506474343647555832008-02-25T21:35:00.000+03:002008-02-25T21:35:00.000+03:002008-02-25T21:35:00.000+03:00I totally agree with you. I have previously experienced the same problem and trust me I was not pleased. <BR/>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.<BR/>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.<BR/>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.<BR/><BR/>The solution that was written on Microsoft Access Help feature was I should “Compact and Repair” the file. <BR/>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!<BR/>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.<BR/><BR/>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!<BR/><BR/>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.Dray Mcoynoreply@blogger.com