recordlock ms access 97

[blad3runn69]

Hi was hoping someone could shed a bit more light on ms access record locking

'Lock the edited record' option is very misleading - when you read the help file it actually states (from 'About choosing a record-locking strategy in a multiuser environment')

'Microsoft Access locks the record you're editing, so no other user can change it. It might also lock other records that are stored nearby ' < this seems very vague can any1 elaborate on the might lock other records comment?

is there a simple way to recordlock in vba as the builtin 'lock edited record' opition seems to be affecting nearby records (ie. if you simeltaneously open records for editing which are located close to eachother in the table access throws runtime error 2448 You can't assign a value to this object...)

thank you :)

[limperger]

Hi was hoping someone could shed a bit more light on ms access record locking

'Lock the edited record' option is very misleading - when you read the help file it actually states (from 'About choosing a record-locking strategy in a multiuser environment')

'Microsoft Access locks the record you're editing, so no other user can change it. It might also lock other records that are stored nearby ' < this seems very vague can any1 elaborate on the might lock other records comment?

is there a simple way to recordlock in vba as the builtin 'lock edited record' opition seems to be affecting nearby records (ie. if you simeltaneously open records for editing which are located close to eachother in the table access throws runtime error 2448 You can't assign a value to this object...)

thank you :)

Hello!

I understand that you are referring to the record-lock option that appears as a tick if selected (only has 1 option, selected or not selected). To the best of my knowledge, this option has little to do with real and practical sharing of the database, so you could even ignore it. The good one is the option above, with 3 different options to select. Set it to entry (or record) lock (edited record).
If you work with forms, do not forget to set a record-level lock, in the Form properties>Data properties>Reco rd locks>Edited record, so the entry-level lock will be displayed in the form.

Best regards