-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|