Locks and Cursors

From: Randi White (rwhite_at_nsaero.com)
Date: 02/19/04 

Date: Wed, 18 Feb 2004 21:40:12 -0700

I am trying to convert a D5 BDE Paradox app to my first D5 ADO SQL 2000 app.
I may have several users trying to access the same record simultaneously I
am missing the functionality that the BDE offers up front when a record is
locked ie 'record is locked' BEFORE users start editing. Looking at the
MDAC SDK I interpret that I need to set pessimistic lock and dynamic cursor
type for 'locking up front' but when I attempt to do that and open the table
or query , the IDE sets the cursor TYPE back static on me and the lock to
batch optimistic. If I set the cursor LOCATION to server with pessimistic
and dynamic I get error "Dataset does not support bookmarks which are
required for multi-record data controls."

If someone shed some light on how to achieve the desired results, it would
be greatly appreciated.

Thanks in advance