Can someone please help me out with this? I am using VBA within Access and
would like to use ADO if feasable, so as eventually, I can see about having
the data taken over to MS SQL Server, but have to build my DB program, get
it working, and I do have various requirements involved. One of these
requirements is dealing specifically that I must be able to have Record
Level Locking finctionality. I would hate to have to create a work around
solution just to get what I would like to do as one would think it would be
less efficient not to mention the various things I would have to take into
account with regards to concurrency issues.
What must I do to have record level locking mode within an Access DB file
via ADO programming using MS Jet 4.0 OLE DB provider?
I have already created work arounds dealing with:
Record numbers to allow for check digits
Data validation to allow for mouse users to click on certain form controls
such as a form reset command button without triggering the data validation
code, but yet, still allow for the stringent data validation checks to take
place should the user click or move onto something else that requires the
data to be checked before moving on. This custom centralized code was not
easy to program as there were a lot of things I had to take into account,
but it's working like a charm for me now. One may say to use the
BeforeUpdate Event, but that causes issues with mouse users as I indicated.
However, for my code to work, FORMS AND CONTROLS MUST BE UNBOUND, which in
turns creates the need for me to work with ADO and/or DAO coding.
I have found an issue with DAO coding that's inconsistent to how it's
documented dealing specifically with it's Edit Mode, which does not work as
it should. For this reason, I have turned to ADO coding and see if I can
get what I need and require, and at this point, I'm not finding the
solution, but I'm also currently chalking it as a learning experience and
have been for the last week digging into the OLE DB provider stuff and it's
DAO does not support row-level locking directly but there are some workarounds using ADO. See if the
PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60
Paul ~~~ XXXX@XXXXX.COM
Microsoft MVP (Visual Basic)