Securing database on a shared network drive

[Guest]

Ive created a database and set up a new workgroup info file which is accessed
using a shortcut (MSACCESS/System.mdw/Database file). All my groups and
permissions work when the shortcut is used, but users can access the database
as if it was unsecured by not using the shortcut but opening it through the
network drive. Any ideas how I can secure this without creating a new
secured network drive and preventing access this way?

 

[Keith]

Ive created a database and set up a new workgroup info file which is
accessed
using a shortcut (MSACCESS/System.mdw/Database file). All my groups and
permissions work when the shortcut is used, but users can access the
database
as if it was unsecured by not using the shortcut but opening it through
the
network drive. Any ideas how I can secure this without creating a new
secured network drive and preventing access this way?

You need to remove permissions to all objects (incl the database object)
from the "Users" group. You may also have missed other steps. See the FAQ
on security and the example on my website.

Regards,
Keith.
www.keithwilby.com