Implementing network user security

[Rusty]

hello,

i am installling my db on our work network and sharing it with all our
users but our user level security dosent work all. It is only implemented
on the db on the server. How do you install security for all the users on
the network based on the copy on the server? thanks alot.

eric

 

[Joan Wild]

Put the mdw file on the server as well, and give each user a desktop
shortcut to open the mdb using the correct mdw file, as in
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[Joseph Meehan]

Maybe if you told us a little more about what you expect from the
security we might be able to make better recommendations.

It sounds like you need workgroup security set up. See:

http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Read it real carefully. If you try to implement it, do test it out on
some test files first.