I have created a table, which i want to use as a reference for validation checks. I have created a form which when i sign in as a username, it should check against the table and allow me to continue if my username is on the list. I hope that makes sense.

Why don't you use 'user level security'. This is a much better and more secure way than a simple table of user names for applying restrictions on certain users.

Im sorry kevin...User level security..i dont understand...how do u get to the option in access. Thankyou

It is a big subject, too big for me to go into. Read up on it on the Help files. Also there is a 'Wizard' in Access that should help you.

What KevinM is suggesting is that you sound like you are trying to do some kind of security for access itself.

Based on a password the user supplies when the database starts then they are either allowed access to the database with certain types of permission which you can assign or they are not allowed access at all.

In other words they may be able to veiw a form but not change it. They may be able to view and change a form. All of this is based upon the original password.

As to whether this is what you are looking for or the best way to do it it depends on what it is you really want to do. User level security may not be what you want.

If you would still like a sample of how to create a form which allows a user to input a name or password or whatever and then there is a check to see if it matches one in a table send me an email and I will send one along. This process does in fact have its advantages over User Level Security if you are using it for the right reason.

However as KevinM suggests you may want to check into User Level Security and all of its options and usages simply to be aware of its possibilities. Including the fact that it can be bypassed!

Good Luck

[This message has been edited by DES (edited 04-25-2001).]