I have an Access 2007 database that has Fluid records (meaning various fields within them can be changed) and later they become Static records (meaning that thereafter no fields within that record should change).
Is there any way I can lock a record within a table so that the data in the various fields in that record cannot thereafter be changed without first unlocking it, but allowing data in other records to be changed as required.
I need a lock per record - i.e. that applies to all fields in that record, and not per field - i.e. that applies to that field in all records.
Is this possible?
Thanks
Is there any way I can lock a record within a table so that the data in the various fields in that record cannot thereafter be changed without first unlocking it, but allowing data in other records to be changed as required.
I need a lock per record - i.e. that applies to all fields in that record, and not per field - i.e. that applies to that field in all records.
Is this possible?
Thanks