Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: how to avoid another Access 2010 disaster?

06 Dec 2013   #1

Windows 7 Pro 64-bit
how to avoid another Access 2010 disaster?


Yesterday I was looking something up in MS Access 2010, which I use often. I don't recall even changing any records - I was only looking something up. When I closed Access, I received an error message. Unfortunately I was quite busy at the time, and neglected to actually read the error message (very unlike me - I almost always read error messages).

About five minutes later I opened Access again, and received a message that my database could not be found! So I manually searched for it, and what I found was that my database was actually gone! There was a new database named database.mdb (my original database was of course .accdb), but I couldn't open it because I got this error:
The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.
I'm the only one that ever accesses this database, and as stated I didn't even change anything. I only had one form open - no tables, no queries, no reports. I researched the error message and found that it's fairly common. (Why doesn't MS fix it?)

So my question is: how can I prevent having it happen again?

My System SpecsSystem Spec
07 Dec 2013   #2

Windows 7 Home Premium 64 bit sp1

I am using Access 2013 as part of my Office 2013 Pro & I searched through the help files & there was mention of earlier versions of Access that saved the database as .mdb. This lead me to ask if you have been using Access prior to version 2007. Version 2007 was when the change was made from .mdb to .accdb. I thought that perhaps there may still be old files you may have,that have not been converted over to the new .accdb format & this is causing a relapse to an old format.
Just a thought that may help, or perhaps spark a memory.
My System SpecsSystem Spec
07 Dec 2013   #3

Windows 7 Pro 64-bit

Hello Ranger4,

I created the database over 10 years ago as an .mdb in MSO 2000. I converted it three years ago when we got new computers and upgraded to MSO 2010, and haven't had any trouble with it since that time.

Once I was able to restore my original file yesterday (I'm so glad I have redundant backups!), I ran the >Compact and repair database function because I was receiving a notice that some features had been disabled, and that resolved the message.

In researching this issue, I've seen it suggested to compact and repair on a regular basis to ensure the database stays clean. Perhaps the crash was caused by a slow buildup of small issues, and that kind of preventive maintenance might be the answer to my question of how to avoid this happening again in the future. To that end, compacting and repairing is going on my list of regular things to do, and I'll keep my fingers crossed I never have to go through losing my database again!
My System SpecsSystem Spec

07 Dec 2013   #4

Windows 7 Home Premium 64 bit sp1

Hi ComicJest. Actually I Compact & Repair my database as well on a fairly regular basis. I have only recently started using Access again. My first experience with Access goes back to Version 1.0 which, I think, came out in 1992, with Windows 3.1. Then to version 7 after Windows 95 was released.
I was actually surprised how quickly I was able to adjust to the latest version, as it really is still very similar. Of course I was very rusty in remembering how to set up a table, but after a few trial & errors I was able to get it done.
My System SpecsSystem Spec

 how to avoid another Access 2010 disaster?

Thread Tools

Similar help and support threads
Thread Forum
Which windows updates do I avoid on win 7 to avoid windows 10 adware?
Which of these updates do I need to avoid in order to not get the "upgrade to windows 10!!!!" adware installed again? I currently don't have it installed (I had to go through a lot to get it that way) and want to keep my computer adware free. SEE ATTACHED JPEG Anyone know? Thanks! -Zooga
Windows Updates & Activation
How to block Windows 7 Updates to avoid clobbering Citrix VPN access?
Hi My spouse's laptop has Windows 7 Professional and it contains a Citrix client VPN access to her work. For some reason, I do not have the details, Windows Updates clobbers the Citrix client, thereby she cannot access her work. Note that Windows performs these updates without asking the...
Installation & Setup
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
avoid pc disaster by being prepared.
unfortunately disaster strikes us all eventually here are a few steps to help prepare you for when it hits your new windows 7 rig. if you bought your pc from an oem manufacturer odds are it didn't come with a recovery disk, creating one should be near the top of your priority list when setting...
System Security

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 14:22.
Twitter Facebook