Error Message Trying to Save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to save changes I made to a query, however each time I try I get
the following error message:

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

I understand the message, however, there is no other user. Just me. No one
else. I have made sure that no other forms, tables or reports are open.

Can someone help me out here?

BTW--I'm using Access 97 and the database is split. Not sure if you needed
this info or not.

Linda
 
At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Try closing the database and seeing if there is a .ldb file with the same
database names in the folder(s) holding the FE and BE. If so, delete them and
see if that helps. Also make sure that you have read, write, create, and
delete privileges to the folders holding the database files.

If that doesn't work, it could be a corruption problem. If you were changing
records or you were using a newer version of Access, I could see a couple
other possibilities; however, you shouldn't be getting that error while
making design changes to a query.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
 
Fabulous......I downloaded the JetComp.exe and it fixed the problem right
away. I think I'm going to use it on a big old hulkin database that is prone
to crashing. Of course, I'll back it up first!!!!
 
Back
Top