I am performing an update SQL through an ADO command object on an Access database table. The commandtext is something like: UPDATE table SET field TO TRUE WHERE othertable!otherfield IS TRUE .... And it gets about 2/3 through the update when I get error: 'could not update; currently locked'. I run it again, and it locks at the same place.

Then I ran it as an update query in Access and it locks up again, only a little further on. I get the error: Could not update due to lock violations.

The database is on a remote server, but I am the only one using it. The default record locking is set to no locks, and the open mode is shared.

The update must be locking itself out, but is that possible? And what do I do about it?