I have an Access front end that gets used on multiple computers in a network. In the master file, under the Tools-->Options-->Advanced Tab, I have set the record locking scheme as follows:
Default Open Mode: Shared
Default Record Locking: Edited Record
Open Database Using record-level locking box is CHECKED
On certain computers on the network when I copy the master file over, these settings change to:
Default Open Mode: Shared
Default Record Locking: No Locks <--
Open Databases using record-level locking box is CHECKED
My first question is why is this happening? My second question would be is there anyway to force these settings using VBA?
Default Open Mode: Shared
Default Record Locking: Edited Record
Open Database Using record-level locking box is CHECKED
On certain computers on the network when I copy the master file over, these settings change to:
Default Open Mode: Shared
Default Record Locking: No Locks <--
Open Databases using record-level locking box is CHECKED
My first question is why is this happening? My second question would be is there anyway to force these settings using VBA?
