User permission setup

[alvintse]

Hi,
Can anyone shows me how to set up the user/group permission for Access 2002?
What I want to do is setup a password for every user. Base on their login password, the the user can access only part of the tables/query/report from the database.

Thanks.

 

[me2you]

You will need to join (or create and join) the appropriate workgroup, then open up the access database. Form your “tools menu/security/user and group accounts”, set up appropriate users. Then from “tools/security/user and group permission”, set up appropriate permissions for each user on the particular database object.

Hope this is of value.

Peace,

me2you

 

[dfletch]

Thank you me2you, I could not find this info anywhere on the MS site!!! big help thx