User Level Security Enquiry

[Sunny Ho]

I am currently using MS 2003 and work on a multi-user database.

I have reviewed previous posts in the forum and followed their advise
achieved in spliting the database to FE and BE, and converting the FE as MDE
file to protect the codes and Forms in the database.

I am proceeding to User Level Security but encountered couples of problem.
1) I could not could not set User Level Security in an MDE file?? is that
true??

2) I am now sharing the database by deploying FE copies of MDE file to the
other users' PC, is it the same after setting User Level Security MDB??

3) I found that there is a MDW file as well, and another shortcut was
created for logging to the protected MDB, whenever each time I deploy them as
2) at above, errors comes about not having permission in access to the MDB,
likely due to lost of linking with the MDW file and the MDB file how to solve
that??

Do I really need to modify the properties inside the "short cut for the
secured database" everytime for every users' PC manually??

4) I have tried to use the wizard to create the User Level Security, but it
seems that it had limited the "permissions", I would like to create my own
define permission, how could that be??

I have gone through almost all the post and tried out lots of
recommendation, I am desparated and please give me a hand.

Thank you very much~~!

 

[Arvin Meyer [MVP]]

There are a number of things that you need to read carefully to implement
User Level Security:

Security FAQ
http://support.microsoft.com/support/access/content/secfaq.asp

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm