Hi guys,
After running an update query, I would like to lock all of the records on the table that was just updated using VBA. This is because the update query only needs to be run once and after that other data will be generated using these fields so I would like to prevent them from accidentally being changed unless the user over-rides it. Therefore, I would also like to be able to attach some code to a button to unlock the table as well. Any ideas?
Thanks
After running an update query, I would like to lock all of the records on the table that was just updated using VBA. This is because the update query only needs to be run once and after that other data will be generated using these fields so I would like to prevent them from accidentally being changed unless the user over-rides it. Therefore, I would also like to be able to attach some code to a button to unlock the table as well. Any ideas?
Thanks