In ADP, Form!BLAH.Recordset.LockType = adLockOptimistic, OR HELP MY BLOODPRESSURE!
Posted on 2000-02-16
Ok, I have a deliverable on the 17th. I have 1 problem left to takle. It seems that microsoft has assumed with their new .ADP file format that all the forms should default to optimistic locking. While this all fine and good, I ****_NEED_**** pessimistic locking.
Is there some property I can set in my connection string, or some option (There is _nothing_ in Options/Advanced about locking, I've been checking daily to see if some how something "magically" appeared.) I've been racking my brain, and all the resource I have here, but I'm stumped. Short of setting the recordset to an optimistically locked recordset, I don't see much in the way of a solution.