How to create a login system in Access?
Posted on 2007-10-05
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?