Is it possible to have a Switchboard Menu with options for "User Tools" and an option for "Management Tools" that would allow anyone entering the 'User Tools" would have "Read Only" Access and the individuals selecting the "Management Tools" would be able to Edit. I've created a password for the overall database access but I am stuck on separating the "Read Only" users from the "Edit" capable.:banghead:
Password and Read Only
- Thread starter ThomTom12
- Start date
The answer is...it depends.
Are your users restricted to using a form front-end or do they have full access to the database tables (data)?
In the first case - you can change the form on_open to lock appropriately, depending on which switchboard option is selected.
In the second case -- it will be very difficult to prevent any user from changing whatever they like.
David R
I know a few things...
- Local time
- Today, 04:30
- Joined
- Oct 23, 2001
- Messages
- 2,633
Why are you granting them direct access to the tables? way2bord isn't talking about the data within them, but you should be filtering them through queries or forms first. Your users WILL blow things up on you accidentally...
Barrie Yeomans
New member
- Local time
- Today, 02:30
- Joined
- May 30, 2013
- Messages
- 4
Hear hear! Users are your biggest issue, the whole point of a Form is to keep users at arms length from your database otherwise you may as well give them an Excel spreadsheet to play with.
I don't even like Forms linked to Tables - all mine are Unbound and use events like 'On Update' to decide what to do with user input. Bound forms that simply pass input to the database may be easier but you really have to think about error handling and what the user might get up to.
You can create a 'Management' form (Form-A) with whatever level of freedom and then simply copy it as Form-B, in which, for example, all the text boxes are locked. They look identical but the password decides which of the two forms is actually presented to a given user.
I don't even like Forms linked to Tables - all mine are Unbound and use events like 'On Update' to decide what to do with user input. Bound forms that simply pass input to the database may be easier but you really have to think about error handling and what the user might get up to.
You can create a 'Management' form (Form-A) with whatever level of freedom and then simply copy it as Form-B, in which, for example, all the text boxes are locked. They look identical but the password decides which of the two forms is actually presented to a given user.
Similar threads
