How to resolve a record locked problem?

[Cesar Ronchese]

Hi All.

I'm doing a maintenance in a program full developed with MS Access 97
(database + forms). Recently, the customers have upgraded his Office
version to XP.

After it, they are getting problems on update their data (MSAccess forms).
The problems are about record locking, saying something like "The record is
locked by another user in this session". Reiterating, this issue didn't
happens when computer had office 97.

I disconnected all the accesses to the database to see if there are others
users locking the record, but It occurs when are only one user on the db.

So, what I'm needing is:

- there are some manner to disable the default MSAccess behaviour, changing
from pessimistic locking to optimistic locking, so the problem will not show
anymore?

- or someone know any other way so I can resolve it?


PS.: the customer will change this MSAccess software to a .NET+SQL software
in a few months, so the solution can be palliative.

 

[Cesar Ronchese]

I've checked that. They have full permission on the sharing and on the
Windows folder security.

I brought all the related MDBs to my PC and recreated the ambient. Then,
other thing I noticed is, the first time I try save the record, its Ok. The
second time the error raises, even when closing and opening the Access
again.