G
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
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