Access Multi-User Password

[cihow81]

Hi,
Are there anyway that we could set Multi-user password to the database file instead of Access Program itself? I would like to create only a muti-user password for that particular database. Thanks for any help...

 

[ghudson]

Yes. Use the menu option... Tools / Security / Set database Password...

Earlier versions of Access [2000 and older] were very easy to break.

 

[cihow81]

Access Passwords

Hi,
In that case, i am only able to set one password for tat database. I need a muti-level user password for tat particular database only... IF A opens that database wit his login ID n password, he cld only access that amount of information. IF B opens that database wit his login ID n password, he cld only access differernt amount of information.

From the Access Text that i have read so far, we cld only set multi-level user password only to Access Program n not to any particular database itself ( I might not have read enough text, n i might be wrong). I hope to set different multi-level user password to different database tat i have created... But i really dont know whether Access is able to do it.. Can you or anyone kindly advise on this, thanks.... I think it will be great if we cld set multi-level user password for any database that we have created...

 

[ghudson]

You need to secure your database with Access security so that you can assign a workgroup and user permissions for each user. You need to search the forum or Microsoft on how to secure your database. You must understand what you are doing and how Access security works before you secure your database. Ensure that you backup your database before, during and after you play with securing it. Securing a database covers too much material to just post a how do I do it. Search the forum for the keywords "security" & "system.mdw" and that will get you started.