asked on

Create form for user's interface in access 2013

i have data base and want to allow certain users to use it, in which users addition and deletion by the administrator and assign read & write permission customized for each.
i want the data base to indicate each action is done by whom.

ASKER CERTIFIED SOLUTION

Jacques Bourgeois (James Burger)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

I agree that security is not Access does well. There are asko special things yyu must to to aklloiw a database to be shared by multiple users.

Since you want multiple users you will also need to split the database into a app (front end) and data (backend).

Check out out this template:

http://www.candace-tripp.net/download/boilerplate2k.zip

Boiler Plate Database
This is a moderately advance database that encorporates a number of functions such as 1) user logon 2) table reattachment 3) user tracking 4) how to control access via the use of modal switchboards and more. FYI: Username = admin; Password = admin.

Dale Fye

As others have indicated, doing what you want will involve some additional programming, but not really much.

When I need to control who has access to or restrictive permissions on a particular form, I create a new table which contains the users Windows UserID (use this API call), the form name, and a permission level (Full, RO, None).

Then, in the Form_Open event, I use a DLOOKUP to determine the users permission level for that form. If it is "None", I popup a message box advising the person that they don't have permissions on the form and if they believe they should, they should contact the application administrator. I then set the Cancel argument to true to cancel the Form Open operation.

If it is "RO" (read only), then I popup a messagebox reminding the user that they only have RO access, then I set the Forms AllowAdd, AllowEdits, AllowDeletes properties to NO. Otherwise, I simply open the form.