Microsoft access - Technical question.?

Question

I am creating a log-in form in Microsoft access, I've got a user name and passwords set up in a table but I am having trouble coding the access button to log me in to a splash screen, do you know what the coding should be for this? so if the password is incorrect for the user name it shouldn't allow access to the rest of the database.

Answer 1

The Northwind sample database should be able to help you with using buttons to open forms:

http://www.microsoft.com/downloads/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=en&hurl=A2A283764D4F2F99B9EC3E401C4C505E&QueryID=1FmATwRwp0&respos=1&rt=2&pid=CD010226021033

http://office.microsoft.com/en-gb/access/HA010546951033.aspx?pid=CH011508321033

You'll probably want to assign the button's onclick event to a module that discovers whether there are more than 1 record matching the provided user name and passwords. If so, the correct form will be opened.

However, I'm not sure why you want to do this. As a previous answer noted, security is already built in to Access, and your system won't prevent a user from simply opening the given form anyway.

Answer 2

Hey, you can create a secre database using the Security functions within Access, creating membership and groups. This way access will prompt for a user name and password upon access. You can also use this function setup the group memberships alowing certain parts to be visable for certain groups.

Try using the Access Help function for details on creating security groups.