How to use form to manage multi-user login

[alvin8866]

Hi Guys,

I am working on a db for a restaurant expense account. I am trying to design a multi-user login form to allow administrator and other users to log in the data entry form. I am a newbie to MS Access.

I recently found a demo on youtube on "Microsoft Access Database Tutorial - User form Login Security Demo"
you can search the title on youtube since I am not allow to post Hyperlink yet.

How could I possibly do this?

 

[pr2-eugin]

Hello alvin8866, Welcome to AWF..

There should be several examples on this Forum for 'Login Forms', just have a quick look around.. I will just summarize what you need to do here, to get this going..

* First your Database needs to be split into FrontEnd and Backend.. The frontend (a separate individual copy for everyone) will be used by the users/admins to do data entry and the (one single) backend will be placed in a network location..
* Then create a table that will have information like AgentID, userName, password, accessLevel
* Create an Unbound form and set it to open by default, under Options->Current Database->Open Form->(Choose the Login Form from the drop down menu)

 

[alvin8866]

thank you pr2-eugin,
I read the article, and I am thinking if Admin and users are all using one db file, and do not have any network or sever. how do I secure within one db file?

 

[pr2-eugin]

Allowing multiple users to access the same file is very risky, and make more room for corruption of the DB.. If you want multiple users to use the DB, then you have to Split the DB and distribute the front ends to all users and keep the backend out of reach (i.e no direct access)