I have written an application that reads, writes, and deletes to an Access 2000 shared database using VB6 and ADODB recordsets. In Access the record locking level is set to Edited record and in VB I have set the ADODB.Recordset lock type to adLockReadOnly. My problem is that when I come to test the locks, they don’t appear to be in effect. I have set a break point in the code just after the recordset is opened, I then go into the database through Access and attempt to delete the record and it lets me!
I am using the Microsoft.Jet.OLEDB.4.0 provider.
Any help would be greatly appreciated
