Hi All,
I have a DB split into FE and BE used in a network environment in which I need all bound fields and and subforms locked until the user clicks an edit button to allow edits.
In the header of each form is fast find utility using an unbound textbox for criteria and an unbound listbox to show the search results.
When the user clicks the next/previous record button I also need the form to lock itself again.
I thought I could simply use the Allow Edits = No and when the Edit button is clicked reverse it, which is what the allow edits is designed for right.
This works however the fastfind textbox and listbox also get locked rendering the search useless as the user can't select a record in the results listbox.
Have tried opening the forms using acFormReadOnly but this doesn't seem to function at all because the form is still completely unlocked.
I have a sub and function that locks all bound controls however everytime a user navigates to the next/prev record the form needs to cycle each control and lock it. Some forms have alot of controls and this tedious task bogs down some of the older machines specially if more than one person is trying to access the same record.
It seems silly that access also locks unbound controls.
Does anyone have an easier way to do this or any suggestions?
Using Access 2010, FE is installed on user machines and BE is installed on network share.
Thanks In advance
Edit:
Ended up using a User Mode system where Administrators have no locks and the other group have locked fields using locking function.
I have a DB split into FE and BE used in a network environment in which I need all bound fields and and subforms locked until the user clicks an edit button to allow edits.
In the header of each form is fast find utility using an unbound textbox for criteria and an unbound listbox to show the search results.
When the user clicks the next/previous record button I also need the form to lock itself again.
I thought I could simply use the Allow Edits = No and when the Edit button is clicked reverse it, which is what the allow edits is designed for right.
This works however the fastfind textbox and listbox also get locked rendering the search useless as the user can't select a record in the results listbox.
Have tried opening the forms using acFormReadOnly but this doesn't seem to function at all because the form is still completely unlocked.
I have a sub and function that locks all bound controls however everytime a user navigates to the next/prev record the form needs to cycle each control and lock it. Some forms have alot of controls and this tedious task bogs down some of the older machines specially if more than one person is trying to access the same record.
It seems silly that access also locks unbound controls.
Does anyone have an easier way to do this or any suggestions?
Using Access 2010, FE is installed on user machines and BE is installed on network share.
Thanks In advance
Edit:
Ended up using a User Mode system where Administrators have no locks and the other group have locked fields using locking function.
Last edited:
