Login form for MS Acess Database

[mudassir92]

Hello there, I have browsed the internet and have found some examples of multiple user logins and have tried some of them- however they do not work for me for some reason, please could you point me to the direction of where I can find a working example- I would greatly appreciate it- its for an A Level ICT project for a system I need to create.
Many thanks

[patjones]

You're asking a really broad question, and so the best we can do is give you a really broad answer. I've implemented log-ins for several of my Access projects.

The level of complexity that you're looking for depends on your needs. Generally though, it's as simple as having a table that stores user ID and user password (and the person's actual name depending on if it's needed). Your database needs a small form that has two corresponding text boxes and a button. If what the user types into the text boxes does not correspond to what is in the table (you check this by using a simple query), then you throw an error; otherwise, if the entries verify then the form closes and you open up your project's main form.

If you can manage to get to this point, then we can assist with specific problems that you have. We will not under any circumstances develop a full solution for you.

Pat

[mudassir92]

Thanks for a prompt reply Pat!
let me give you some background information.
I am creating a Booking system for a cleaning company (not a real company just for a project for A-level) and i would like the staff to have logins and passwords. The manager only employs one person but may employ some more later on. So basically what i gather is that 2 current users need to be able to login (manager and the employee) and an option to add more logins (for more employees if needed). Thanks- does that help?

[patjones]

Not really. I'm not sure what you're looking for here. I've given you the direction that you need to take. This is really all I can do, short of laying the procedure out for you step by step (which is not what we do here).

There's nothing wrong with asking a broad conceptual question (I do it myself sometimes); however, you need to try and implement your vision first.

Once you have the form, the table, the query and the VBA code arranged to make this work, we can assist you with specific problems that you run into. I can't really see any other way to go about it at this point.

[RisoSystems]

You might take a look at the Northwind sample database that is bundled with Access. It includes a very well-documented user management component.