VBA and Access

[GRitchie]

Background information:

I have a table with a list of usernames and passwords, these are the accounts to login to the database.

A form is set to ask for the username and password, upon pressing login, if they can validate they are sent to appropriate form.

If not, there is an error.

 

 

The issue I'm having is, when users are typing their username/password into the unbound fields, it can sometimes edit the actual records in the table somehow?

Usually it's only the first record, but this means sometimes accounts are duplicated and therefore you cannot get into the database with that account.

 

I want to lock the employee accounts table.

 

I've tried using Me.AllowEdits = False on the form, but then I receive an error on load and it won't let me type into the unbound text fields?

 

 

Help!

 

Any more info needed?

Ask away!