J
Jessica Gartner
Hiya,
I have an access database that I cannot open today but it
worked fine yesterday. I am the only one in our LAN who
has Access and I am sure that nobody else is editing
records. I can't find anything in the knowledge base
that applies to this situation. I have tried Compact and
Repair and I get the same error as when I try to open the
file. Is there anything I can do?
Thanks
Jessica
The error help is below
The Microsoft Jet database engine stopped the process
because you and another user are attempting to change the
same data at the same time. (Error 3197)
This error can occur in a multiuser environment.
Another user has changed the data you are trying to
update. This error can occur when multiple users open a
table or create a Recordset and use optimistic locking.
Between the time you used the Edit method and the Update
method, another user changed the same data.
To overwrite the other user's changes with your own,
execute the Update method again.
I have an access database that I cannot open today but it
worked fine yesterday. I am the only one in our LAN who
has Access and I am sure that nobody else is editing
records. I can't find anything in the knowledge base
that applies to this situation. I have tried Compact and
Repair and I get the same error as when I try to open the
file. Is there anything I can do?
Thanks
Jessica
The error help is below
The Microsoft Jet database engine stopped the process
because you and another user are attempting to change the
same data at the same time. (Error 3197)
This error can occur in a multiuser environment.
Another user has changed the data you are trying to
update. This error can occur when multiple users open a
table or create a Recordset and use optimistic locking.
Between the time you used the Edit method and the Update
method, another user changed the same data.
To overwrite the other user's changes with your own,
execute the Update method again.