Access Controls in Access

[Hanny J]

How on access can you set access controls to your users?
If they log in with one username and password they can just read
information and if they log in with another username and password they
can read and write?
I have no idea how to do this, is it even possible??

Thank you

[Brian]

Try playing with the access security tool, you can add users, groups,
passwords, read/write allowances etc. to your database using that.
Its under the 'Tools' menu of Access.

[Salad]

Brian wrote:

Try playing with the access security tool, you can add users, groups,
passwords, read/write allowances etc. to your database using that.
Its under the 'Tools' menu of Access.

Playing is not the proper word for it. I would never "play" with
installing security without a backup copy of the System.mdw file or a
backup of the application.

You should also recommend the SecFaq when "playing" with security.
http://www.mvps.org/access/resources/techpapers.htm.

Dangerous
http://www.youtube.com/watch?v=ASIVv_LiBoU

[Brian]

Yeah i suppose playing wasn't the correct word for it.

[Hanny J]

Hey

Thanks for both your help. I'll try that.

[Larry Linson]

"Hanny J" <ha********@aol.comwrote

Thanks for both your help. I'll try that.

Note that a well-versed author and authority, Roger Jenkins, back in the
days of Access 2.0, characterized Access' Security as "labrynthine". It has
not gotten any less complex, and I caution that, while it is "doable" it is
"not for the faint of heart".

But, be sure to get, read, study, and re-study the Security FAQ. My
recollection: it is 39 pages, and, believe me, there's no "filler" --
everything written there is important.

Larry Linson
Microsoft Access MVP