| Author |
Error in multiuser environment
|
|
|
| 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 2006-04-05, 9:35 am |
| 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.
| |
|
| 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" <Ron.Nemec@bigfoot.com> wrote in message
news:1144243502.184717.11400@j33g2000cwa.googlegroups.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 2006-04-06, 7:41 am |
| 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 2006-04-07, 7:42 am |
| 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
|
|
|
|