Access security on a server

[Marcus]

After I set up a security workgroup for an Access 2002
database stored on a windows 2003 server, it works
perfectly when tested at the server's console but anyone
opening the file from a workstation does not get the
Access login dialogue, and the database opens in
unsecured mode. How do I get the security workgroup
settings I've set up on the server to apply across the
network? I've read that Access security settings only
apply to the machine on which they were established.

 

[Rick Brandt]

After I set up a security workgroup for an Access 2002
database stored on a windows 2003 server, it works
perfectly when tested at the server's console but anyone
opening the file from a workstation does not get the
Access login dialogue, and the database opens in
unsecured mode. How do I get the security workgroup
settings I've set up on the server to apply across the
network? I've read that Access security settings only
apply to the machine on which they were established.

If you actually read that the author didn't know what they were talking
about.

If people can open your file without using your mdw file then you didn't
apply security properly. Try again until you get to a point where all
attempts to open the file from outside the server fail. THEN create a
shortcut for all users that specifies the mdw file on the server as a
command line argument.

"path to MSAccess/exe" /wrkgrp "path to mdw" "path to mdb"

Using this shortcut they will be prompted for a login.

Don't just create the shortcut without fixing the security problem first as
you actually have zero security until that is corrected.