VPK_Access
Registered User.
- Local time
- Tomorrow, 01:14
- Joined
- May 15, 2011
- Messages
- 36
HI,
I have a system developed in Access 2003. When I am updating some records it gives me the error "Could not update; currently locked by another session on this machine". This error comes only when I update data on some records in the database.
While searching on the access programmer issues, I found a similar query, which said that the DAO.Recordset should maybe open. I checked my code and ensured that it is closed.
Could anyone help me in telling why this error comes and why only for some record updates.
Thanks for any help in advance.
I have a system developed in Access 2003. When I am updating some records it gives me the error "Could not update; currently locked by another session on this machine". This error comes only when I update data on some records in the database.
While searching on the access programmer issues, I found a similar query, which said that the DAO.Recordset should maybe open. I checked my code and ensured that it is closed.
Could anyone help me in telling why this error comes and why only for some record updates.
Thanks for any help in advance.