using validation to provide secuirty in database

[Guest]

I want to build a security level into an access database in order to restrict
visibility of certain records. I have set up a list to select user name and
run a query on exit to determine what the password should be.

What I now need to do is on exit from the text box where a user enters their
password, access should validate that against the query result and either run
the next form or hold the user at the security screen asking them to retry or
cancel.

Hopefully this should be possible, not sure but would be very grateful for
any pointers.

 

[Joseph Meehan]

I want to build a security level into an access database in order to
restrict visibility of certain records. I have set up a list to select
user name and run a query on exit to determine what the password should
be.

What I now need to do is on exit from the text box where a user enters
their
password, access should validate that against the query result and either
run the next form or hold the user at the security screen asking them to
retry or cancel.

Hopefully this should be possible, not sure but would be very grateful for
any pointers.

I would think that user level security would be easier and more secure.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.