If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need advice on setting record locking
Hello,
I have a BE with many FEs (one for each user) and user level security in place. Previously, only one person has entered data into a certain table. Now it looks like we will need to have more than one person entering data into the same table (again through their own seperate FE). I know that Access should be able to hand this just fine, but I am looking for advice on what level of record locking to pick (no locks, all records, edited record - I currently have no locks selected). Also, how is that related to the check box below 'Open database using record-level locking', which is currently checked in the backend. Is this box something that needs to be set on every machine, or does it go with the database. thanks for any help you can give. CAM |
#2
|
|||
|
|||
need advice on setting record locking
On Feb 11, 4:28*pm, CAM wrote:
Hello, I have a BE with many FEs (one for each user) and user level security in place. *Previously, only one person has entered data into a certain table. * Now it looks like we will need to have more than one person entering data into the same table (again through their own seperate FE). *I know that * Access should be able to hand this just fine, but I am looking for advice on what level of record locking to pick (no locks, all records, edited record - I currently have no locks selected). *Also, how is that related to the check box below 'Open database using record-level locking', which is currently checked in the backend. *Is this box something that needs to be set on every machine, or does it go with the database. thanks for any help you can give. CAM IF all you are doing is adding data from two different front ends, if you set the form to Data Entry, then you only should not have locking or contention problems. |
Thread Tools | |
Display Modes | |
|
|