Usernames and passwords

[Stapes]

Hi
I want to create a database with secure logins with different access
rights.
I thought I could make an admin table in the database with usernames &
passwords, to be accessed only by the admin user.
Then a form to do the login -find the username & password & only let
the user continue if they validate OK.
Different access levels will give different users access to different
parts of the system.
Is there any encryption I can use for storing the passwords - like MOD4
or the like, so nobody could stumble across them?

Stapes

 

[Douglas J. Steele]

Realistically, while Access user-level security isn't fool-proof, it's going
to be better than any home-grown security initiative.

Read the Access Security FAQ thoroughly several times, work on a couple of
your application (just in case), and make sure you don't leave out any
steps.

http://support.microsoft.com/support/access/content/secfaq.asp

 

[Stapes]

Hi
I wanted to open my system on a simple menu (form) with 2 choices -
Frontoffice or Backoffice. Each of these command buttons is to lead to
a log in screen - one for each subsystem. Beneath that, I need to
control access to the tables.

Stapes

 

[John Vinson]

Hi
I wanted to open my system on a simple menu (form) with 2 choices -
Frontoffice or Backoffice. Each of these command buttons is to lead to
a log in screen - one for each subsystem. Beneath that, I need to
control access to the tables.

And you prefer to reject the well-worked out, well documented
Workgroup Secureity system in favor of putting in many hours of work
to develop your own, less secure, system; just so that you can have
the main menu rather than a login screen which would let the user type
"Frontoffice" or "Backoffice" and a password?

Seems like a LOT of work for minimal or no benefit.

John W. Vinson[MVP]

 

[Stapes]

Hey - that's a great idea!
In practice i will need different levels of access within each
category, but I could prefix each username with (for example) front_ or
back_.
I'll get on to it.
Thanks

Stapes

 

[Stapes]

Hi
I am coming along with this project now.
I have set up my workgroup, groups and users, and tested them OK.
I want the database to open on a different form for different groups -
I for the Frontoffice, one for the Backoffice. Is there any way I can
do this? And can I interrogate the User or group name within code?

Stapes

 

[John Vinson]

Hi
I am coming along with this project now.
I have set up my workgroup, groups and users, and tested them OK.
I want the database to open on a different form for different groups -
I for the Frontoffice, one for the Backoffice. Is there any way I can
do this? And can I interrogate the User or group name within code?

Stapes

CurrentUser() will return the log on name of the user; you can use the
Groups() and Users() collections of the current Workspace to identify
which users belong to which groups and vice versa.

John W. Vinson[MVP]