form password

[Guest]

is it possible in access 2000 to protect ONLY a form within the database? i
want certain users to be able to get to the form that generates time cards
but not the form that generates reports (restricted information).

 

[Jeff Conrad]

in message:

is it possible in access 2000 to protect ONLY a form within the database? i
want certain users to be able to get to the form that generates time cards
but not the form that generates reports (restricted information).

Access User Level Security (ULS) will provide the *best* security for you,
but if you just need something simple for a single form and/or report you
could try these Microsoft KB articles:

http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

For ULS information see:

http://www.ltcomputerdesigns.com/JCReferences.html#Security

 

[Rick B]

Do a search. Asked and answered all the time.