-
I am running a program that uses DAO to manipulate an Access database. I open the database and create a recordset. I seek for a record and delete it. Then I close the database. When deleting, I keep getting the following error:
"Couldn't update; currently locked by user 'admin' on machine 'machine name'.
I am doing something like this
DBEngine.Idle dbRefreshCache
QTable.Seek "=", stUniqueId
If QTable.NoMatch = False Then
QTable.Delete
End If
I update the database in other areas in this program and have had no problems until I added this delete.
Any ideas what could be causing this error?
-
Did you using data env. or something else that hold the database? Coz i have the this kind of problem last time when i was using the data env.
-
In case someone else has this problem. It is in a multiuser environment and I have to check if the recordset is updatable prior to deleting.
Thanks anyway