Question The Microsoft Jet Database Engine stopped the process because you and another user ar

[cdoyle]

Hi,
I hope someone has an idea to why this is happening to only 1 user.

Whenever they try and open the db, they get the following 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.

It then shuts the db down.

I have the db split with the fe on their machine, and the be on a shared network drive.

The steps I've taken so far is
reboot their machine (no change)
delete their local copy of the FE and re-installed (no change)
delete the .ldb file (no change)

The db is working fine for everyone else, so I don't think the BE is corrupted at all.

Any ideas

 

[Guus2005]

Sounds like a Access reinstall to me. The error message doesn't make any sense to me.
You could try to put the FE and BE on the same user's directory and test it. If the problem goes away, reinstalling Access is not the answer.

Does this user have problems with other databases or other office applications like Word?

HTH

 

[gemma-the-husky]

you most likely have a form open with an edited record, and have popped up another form with bits of the same record

you can't save the popup form, because the record is dirty from the first form.

One fix is to do

if me.dirty then me.dirty = false (ie save the reocrd) before opening the popup

 

[cdoyle]

Well whatever the problem was yesterday, it seems to be working for her today.

I hate these types of problems, never know what actually caused it.