User Level Security - User Level Security in Microsoft Access Part 1


	Back to User Level Security Comments List

Upload Images Link Email

User Level Security

Michael Newsham

19 months ago

I have checked my typing to spot the issue but I've failed. If I enter a correct user name and leave the password empty the database is opening. I downloaded the template and enter "Richard" in to the user name box without a PW and the DB opens. IS there a missing piece to the jigsaw?

	Scott Axton 19 months ago
Just to be clear -- You are saying the stock sample db is not working either? (I haven't tried it)

	Michael Newsham OP 19 months ago
Hi Scott. Yes. If you enter a correct user ID then the DB will open.

	Scott Axton 19 months ago
Richard I can confirm this isn't working as intended. If you just hit enter at the Username it blows right on by the PW checking. I've tried putting in message boxes and break points and can't figure out why either. To be fair though not a lot of time invest in it.

	Kevin Robertson 19 months ago
I would check to see something had been entered in the field. Perhaps something like this at the top of the sub. `If IsNull(Username) Or IsNull(Password) Then MsgBox "Missing Data" Exit Sub End If`

	Richard Rost 19 months ago
Yeah, a boatload of people have already brought this up on YouTube. I'm going to address it in Part 4.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in User Level Security.