Newbie Q Re: Setting up Security on an Access 2000 DB

[Sharky]

OK...I'm hoping someone will be kind enough to steer me in the right
direction with regard to setting up security on an Access 2000 database.

A couple of questions:

* Beyond setting up basic login security, to what level can I control who
can and can not see what? Forms? Reports? Records? Fields?

Are there any good online resources which might help me get ramped up on the
subject?

Thanks!

Jim

 

[Joan Wild]

A couple of questions:

* Beyond setting up basic login security, to what level can I
control who can and can not see what? Forms? Reports? Records?
Fields?

Yes to all.

Are there any good online resources which might help me get ramped up
on the subject?

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

Other good reads
Lynn Trapp's
http://www.ltcomputerdesigns.com/Security.htm

Jack MacDonald's
www.geocities.com/jacksonmacd

I have outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm