Error deleting with DAO

[richaa]

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?

[hcleo]

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.

[richaa]

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