I am using VB6, Access 97 and ADO.

I am having a problem with getting ADO to lock records
I want to either edit or delete. (I know Access 97 only
supports page locking, its not an issue)

I have setup the cursor location as UseServer and
opened a recordset with pessimistic locking, but
when I access the same record from another workstation
it opens the record no problem, I would have expected some
form of error.

In short can I make ADO lock an Access 97 record so no other user can access it until the lock is released by
the original user.

I would be very gratful for any help