Best way to share Access

[whojstall11]

Currently I have a database that has multilevel user access meaning that I have a (Admin, User, Other) user access option? All three users will have access to the same backend data but all three will have a different frontend form. Now i want to use Sql server to backup my backend table and I want use Citrix to host my frontend forms. How could I successfully do this?
Keep in mind:
there is only 1 person with "Admin" rights, he can Update,add,delete
there could be multiple "Users" at one time, they can only add
there could be multiple "Others" at one time, they can only view

 

[Rx_]

Welcome to the world of Citrix and SQL Server.
First: Lets assume that your Citrix allows one version of the front-end. As each user logs in, a copy is put into each User's Folder. Each user is running their own front-end - linked to the SQL Server back-end.

There are many ways to approach this.
One way might be to write one single Access front-end that looks at the User ID. The User ID might be table driven to reduce mantenance as things change.
Attached a small sample of a table used per form / function. My preference is to use I - inactive A - Active.
There might be 40 columns to allow a Form Level control, Application Level, and a few Control levels.

Since Citrix removes anyone from reaching the code posted at run-time, the USER ID can be used to determine what forms, controls or code is available.
Using the table with a DLookup - and returning I or A, a form's "Edit" button's Visible property could be set to False for one user and True for another.
If asked to add a second person to edit later, it is just a matter of changing the I to an A in the table.
Publishing the table in the Maintenance Design Document (of course every programmer documents their work, right LOL) the table printout provides a really quick explanation of what users should have available.

In my application, there is a second Citrix Access applicaiton that only a couple of poeple can get into. It is not designed to enter or change data. It is designed soly for mangers to view and change the table shown in the attachment. It's name is Maintenance DB. Citrix will only allow a couple of uers to get into it.