Access 2003  to SQL via ODBC - How to lock records

I have converted my mdb backend to SQL Server 2000 which I am now connecting to via ODBC.
I understand that Access no longer handles the record locking.
Most of my forms are simple bound forms.
Do you suggest I convert these to an ADO approach using disconnected recordsets?
If so, please provide a basic example at to how this is done.

1) In our applications, oil related large information systems, we ignore the concurrency problems. Updates to rows are "posted" by Access as updates against the fields that has been updated. We figure that if you update a date, comment etc then you know what it "should be". Of course there might be some piece of information that could get lost using this approach, but the trade for not having locking issues and being able to make use of Access forms/subforms without programming a lot to be disconnected makes it worth it for everybody.

2) We "never" use continuous forms. They don't make good "main forms", also due to our framework, and the have to many limitations as subforms. Users seems to like to datasheet/excel-like form of a normal subform, for some reason :-)