Jet Database says there's another user . . .

[firestorm52]

Has anyone run into this problem before?:

I'm trying to add another field to a query and everytime I go to try and save it I get a pop-up windows that states the following:

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

I understand the error, but the problem is that I'm the only one using this database!! I check to see if there are any extra Access.Lock files but there's only one. Any clue what's going on with this??

 

[spacepro]

Is there a .ldb file when you have closed the db?

Try opening the db in exclusive mode, Open MSACCESS directly then select open exclusive on the Open Dialog Box.

Hope this Helps

Andy

 

[firestorm52]

Thanks for the tip. I tried what you advised but I still came up with that error. On a whim, I decided to copy the query and rename it with the new field included. Somehow it saved without a problem. I then deleted the original query and then renamed the new one with the old name. Don't ask me why or how, but now it works perfectly. Go figure . . .

 

[spacepro]

it sounds like the query or code relating to the query had or is been running when you tried to save the query, thus would not save because of exclusive access to the query. Or it could be a windows thing where the execution within access has hung.

Anyway at least you have it sorted now.

Andy