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?