Error in multiuser environment

[yk]

When I reach a certain record, I receive 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."

I have tried refreshing the record but was unsuccessful.

Hope someone could help me out. Thank you.

[Ron2005]

Are you the only one in the file at the time?
Is this a update Query your are running or are you on a form?

Typically the message means just that, although I believe I have seen
it when trying an update to a record in a currupt table. Although I
think it was usually associated with another error message.

We need more information. If you are NOT the only user then most
probably the message is completely accurate.

[yk]

Thank you for responding to my question. Yes, I am not the only user and I
was on a form when the problem happened. It was not an update query, only a
normal editing of the record. It could not be a corruption of the table
because all other records can be accessed and edited with no problem.

The problem still persisted even after all users have logged-off and
shutdown their PCs and logged-on the next working day. How do I get rid of
it?

Thank you again.

"Ron2005" <Ro*******@bigfoot.com> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.com...

Are you the only one in the file at the time?
Is this a update Query your are running or are you on a form?

Typically the message means just that, although I believe I have seen
it when trying an update to a record in a currupt table. Although I
think it was usually associated with another error message.

We need more information. If you are NOT the only user then most
probably the message is completely accurate.

[Ron2005]

Have you tried a compact and repair on the tables. There can be a
corrupt record that does not kill the file for opening but can stop
your processing of it.

I have seen this before, but can't remember exactly how it was
resolved. I think the compact and repair fixed it, but am not 100%
sure.

Ron

[Ron2005]

I wrote the above message and not 2 hours latter, exactly that occured
in one of our networked tables file. A compact and repair resolved the
problem for us. Maybe it will for you also.

Ron