Password Check

[csdrex87]

Ok so I am kinda new to Access I have managed to create a database and have a form that updates the password into a table after they click a button in the password field. Now what i want it to do is to create a Msg box on my other forms prompting a user for a password then checking it against the password in the table.

I understand this is going to be a lot of code, but what I was thinking is I could either bypass the msg box by having a field on the form and using a Dlookup to check that vs the field in the table. The only problem is im not quite sure of the syntax required. If anyone has any help they can offer I'd greatly appreciate it!

 

[SOS]

How about a sample I came across?

 

[csdrex87]

The sample looks like it works but then when I use the user with less access (i.e.) read only access he can still modify the files so I'm not sure if it actually works. The other thing is do you know the code to put in an alert box cause that doesn't work on that code either.

 

[SOS]

read only access he can still modify the files so I'm not sure if it actually works.

What do you mean? The sample only demonstrates how the edit form is set so that the user cannot make changes to the record and the admin user can.

The other stuff is up to you to put into place. The database window is shown there because this is a sample, not an application. You can set the window to not be there and you can set the enablebypass property to no. But the sample wouldn't be much good of a sample if you weren't able to look behind the scenes and see what is going on.