access database query (urgent)

[Guest]

what does the following message mean:
"the microsoft jet engine database has stopped the process because you and
another user are attempting to change the same data at the same time."

i work in an office where 12 computer are networked and working on access at
the same time. whenever this message pops up, i have checked to see if anyone
else was working on the same file - each time i have been the only person
working of the specific file. this error only occurs on my computer and not
on any of the other 11. please help as this has become extremely frustrating.
the only way to get rid of the message is to actually end the programme.
thank you!

 

[Allen Browne]

This message is the general concurrency error message, that can be caused by
heaps of things.

Prevention is only possible with good development practices, such as:
- Splitting the database, so each user has their own independent copy of the
front end;

- Explicitly saving the record in any bound form before doing anything that
requires the record to be saved (such as coding a move, filter, change of
sort order, closing the form, ...);

- Ensuring the user can only open one copy of the data for editing (e.g.
making other copies read-only), especially where memo fields are concerned;

- Ensuring any user editing is saved before any programmatic process execute
that alters the data;

- Explicitly closing any recordsets opened in code, and setting objects to
Nothing before exiting any code routine (including after error recovery);

- Using an MDE as the front end, so it cannot decompile (which avoids one of
the types of corruption associated with this message).

 

[Danny J. Lesandrini]

One other thing to check, if you're using SQL Server as the back end, is
that each tables has a Timestamp field. It helps Access to determine
when a record was actually changed. Where there is not a Timestamp,
it has to compare fields and sometimes it simply throws up it's figurative
hands and says, "Heck, I can't tell if anyone has changed anything, so
I'll just warn the user anyhow."

 

[messaoudi]

what does the following message mean:
"the microsoft jet engine database has stopped the process because you and
another user are attempting to change the same data at the same time."

i work in an office where 12 computer are networked and working on access at
the same time. whenever this message pops up, i have checked to see if anyone
else was working on the same file - each time i have been the only person
working of the specific file. this error only occurs on my computer and not
on any of the other 11. please help as this has become extremely frustrating.
the only way to get rid of the message is to actually end the programme.
thank you!