Record Level Locking

Does anybody know how to create an ADO connection where record level locking is set instead of page level locking

Thanks

What DB? What ADO Provider?

SQL 7 and MS Access 2000 are the only ones (that I know of) that implement row-level locking, and they will do it automatically

I'm useing access 97 which probably explains why it doesn't work.

Thanks for your help Clunietp