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.
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jacques Bourgeois (James Burger)PresidentCommented:
Access was very powerful as some point, but Microsoft has shifted the focus to simplicity since 2007, and even more in 2013.

User level permissions is a feature that existed in the older versions of Access (.mdb files), but has been removed from Access in 2007 with the new .accdb format.

With an .accdb file, there is nothing built into Access that would enable you to do define individual users permissions. You would need to implement that through a lot of background programming.

It would be easier with a .mdb file (https://support2.microsoft.com/default.aspx?scid=kb;[LN];207793), but even there,  nothing is built-in to automatically log each user action. This would also involve a lot of programming. And if I am not mislead, the old format has been completely dropped in 2013 and is no longer supported.

Unless you have a good background in programming and are willing to spend a lot of hours on such a project (and I mean a lot), I would suggest hiring a professional programmer that could guide you toward a solution such as migrating the data to SQL Server which has user level permissions built-in, and use Access only for forms and reports.

Sorry, in database development, you need to ask those types of questions before you create the database, not after.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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 FyeOwner, Developing Solutions LLCCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.