-
This isn't really vb but i have no-where else to turn!!
I get this error when i try and open a access database:
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 CdbRecordset 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.
But I'm the only person with it open... Deadly certain about this!
Is there anyway i casn get around it?
-
Are you connecting to the db using ADO, or are you using Access as your front end?
-
It's actually my workmates db and she couldn't get into it. So she asked if i could try and fix it.
So yes access as the front end!
-
Try compacting and repairing the db.
If this fails, create a new mdb, then import all the objects. This should work unless you have object level security enabled.
To prevent any record locking errors in the future, if there is only one user, set up the command line option and/or the internal options to open the db exclusively.
Hope you get it up and running :) .
James
