C
Chris v.
Please advise me if this is not the best way to accomplish the desired
result. I am new to Access and have very limited programming experience. I'm
creating a split database. There will be several users with different
permissions to use the database: 1) View ONLY, 2) Enter data using only a
FEW fomrs, 3) Enter/Edit any data using forms, and 4) Administrator (Full
Access to create new queries/forms and edit tables if necessary). I would
like the users to log on the the database as the agency only uses a file
server (this will hold the back-end, and I will install the front-end along
with Access runtime on the local boxes). I'm thinking that there could be a
switchboard for each permission level, which would load after a log-in form
is completed. The different switchboards would all be copies of the main
switchboard, but with comand buttons disabled (and grayed) per users access
to the database. So I have 2 questions: 1) Is this a workable plan and 2) How
do I load the correct Switchboard once log-in is completed? I've only used
macro's so far (I have no VB experience).
result. I am new to Access and have very limited programming experience. I'm
creating a split database. There will be several users with different
permissions to use the database: 1) View ONLY, 2) Enter data using only a
FEW fomrs, 3) Enter/Edit any data using forms, and 4) Administrator (Full
Access to create new queries/forms and edit tables if necessary). I would
like the users to log on the the database as the agency only uses a file
server (this will hold the back-end, and I will install the front-end along
with Access runtime on the local boxes). I'm thinking that there could be a
switchboard for each permission level, which would load after a log-in form
is completed. The different switchboards would all be copies of the main
switchboard, but with comand buttons disabled (and grayed) per users access
to the database. So I have 2 questions: 1) Is this a workable plan and 2) How
do I load the correct Switchboard once log-in is completed? I've only used
macro's so far (I have no VB experience).