Record Locking with VBA

[Guest]

Hi

I am developing an Access 2003 database. It is split into a front end and
back end and will need to be accessed concurrently by multiple users.

Part of the functionality of the database is to allow users to enter
information, often in large memo fields which could potentially be accessed
by more than one user. I hope to handle the editing of records within data
bound forms in vba code - i.e. when a user accesses a record I update a flag
in the record to indicate it is being edited, then if another user accesses
the record it will allow them to view all the information for the record, but
all of the data fields will be locked, preventing the user making any changes.

Can anyone see any problems occuring if I use this approach to record locking?

Thanks

Darach

 

[Henro]

I thought Access already did that by it self? Isn't it somewhere in the
options?

Darach schreef:

 

[peregenem]

Here's a thread from the archives which demos an alternative locking
approach:

http://groups.google.com/group/micr...bbfa0478dd9/f70b1515e6bd9725#f70b1515e6bd9725