squidlings
asked on
How to create a login system in Access?
Hi,
I don't actutally want to know details of how do make this Login, I just want to understand in my mind how to go about it. i.e. a list of instructions like a flow chart.
I have a database I have written for work, it is on the network and soon it will require a user name login/password system.
At the minute it only needs user name & password but in the future I would like to add levels of access. i.e. some users can only read orthers can read and write.
I am aware of the inbuilt security system in access, but I have never used it.
Please can somebody give me a brief idea of how to setup this kind of system.
Am I best using the inbuilt access login system, is it better to have 1 written in VB code?
Where I start?
Do I make a table for user names and passwords?
I don't actutally want to know details of how do make this Login, I just want to understand in my mind how to go about it. i.e. a list of instructions like a flow chart.
I have a database I have written for work, it is on the network and soon it will require a user name login/password system.
At the minute it only needs user name & password but in the future I would like to add levels of access. i.e. some users can only read orthers can read and write.
I am aware of the inbuilt security system in access, but I have never used it.
Please can somebody give me a brief idea of how to setup this kind of system.
Am I best using the inbuilt access login system, is it better to have 1 written in VB code?
Where I start?
Do I make a table for user names and passwords?
<<Am I best using the inbuilt access login system, is it better to have 1 written in VB code?>>
FYI, for the type of thing you want, there really is nothing built into Access to do that. And as of A2007, user level security has been dicontinued. Better to build your own at this point.
JimD
FYI, for the type of thing you want, there really is nothing built into Access to do that. And as of A2007, user level security has been dicontinued. Better to build your own at this point.
JimD
ASKER
Thanks for your advice, 2 more quick question.
How secure is this kind of login system? Or does that depend on your code?
Is there a way to disable the "hold down shift when you open the application" feature?
How secure is this kind of login system? Or does that depend on your code?
Is there a way to disable the "hold down shift when you open the application" feature?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, you've been more than helpful.
At least I know a little more about the strenghts and weaknesses of access now.
Thanks again.
At least I know a little more about the strenghts and weaknesses of access now.
Thanks again.
User table and then a permissions table. User table has name, password, accout disabled types of things.
As for the permissions table, that can vary widely. Generally folks go for a table that specifies the user, a tag (usually the module, such as "A/R") and then a security level from 0 - 9.
In your menu system, each menu item should be in a group (ie. A/R module) and have a required security level (0-9).
When the user double clicks on the item, you check their security level for that group vs what's required.
That's just one example.
HTH,
JimD