I am using VB6, ADO and Access 97

I am having a problem with getting ADO to lock records

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 have read in another post the ADO and OLE DB don't currently support recordset locking and you must use DAO
if you require recordset locking. Is this true?

I would be very gratful for any help