Locking & Referential Cascade

I have a VB5 app using Access 97 database. One of its data entry modules consists of one to many and for each many another many.

Using VB transactional methods, I invoke a BeginTrans while the user enters the relationship records and a CommitTrans when they hit the save button.

The problem I faced is the page locking during an add in transactional mode.
Also I`m relying on DAO to take care of cascade Update & Deletes.

Will SQL 7 solve my problem? Does its row level locking capablities work with this sort of application? Does it handle cascade Update & Deletes? If not can I still use Access and have it linked to SQL so that cascading is maintained?