Help please, Access & record locking

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

[curlywink]

Hi there,

Had d same problem b4 but found out other solution, drawback lots of code to make it work...

Here's the concept add a boolean field to a table that your trying to navigate/manipulate once that record is on active set this field to .T. and to your record movement controls check for records that the boolean field has value of .F. ... Get my idea ????


Hope this works for ya ....