Record Level Locking in Continous Form

[ions]

Hello I am trying to get Record Level Locking on a continous form in Access 2000. I am only familiar with DAO

I've read 2 articles on this topic in MS KB.

1)http://msdn.microsoft.com/library/de...vellocking.asp

This recomendations in the above article don't work for me. It always does page locking.

2) http://support.microsoft.com/kb/306435/en-us "PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60"

This seems to be the solution as many Access MVP's recommend it but I can't get it to work.


Has any one actually implemented level record locking using DAO? Thanks

 

[llkhoutx]

Here's a method I use to lock/unlock records on a continuous form:

1. Lock all displayed data controls / fields which are visible in the form design view and save.
2. On a row control Double-Click, cycle through the form (subform) visible controls and unlock them.
3. On the form OnCurrent event, relock the controls.
4. On and initial form open, the subform opens first, therefore skip the OnCurrent locking, as the form referencing for work because the form isn't open yet.

 

[ions]

I am not sure how this method is helpful. Two different users can still unlock the same record and edit it. Also, this will not by-pass page level locking in my opinion, unless access is smart enough to notice that surrounding records have locked controls.

If I am wrong or am mis understanding your method I apologize. Let me know.

 

[llkhoutx]

Can you restate your question succinctly.

 

[ions]

Hi.

I don't understand how your method implements record locking.

1) Your method enables two different users on different machines to access the same record. All they have to do is double click (Step 2- you mentioned) the same record at the same time and both have access to the same record. They can potentially edit the record at the same time.

 

[llkhoutx]

Imagine that, 2 users attempting to simultaneously updating the same record! Someone is always last to hit the record.

Access Help has a section and example of "BeginTrans, CommitTrans, Rollback Methods." Welcome to the multi-user database world.

 

[ions]

Record Locking makes the scenario you described impossible: 2 users attempting to simultaneously update the same record.

We might be thinking of two different things.

 

[ions]

Anyone suggestions. Examples?