Problem with user-level-secuity

[jsccorps]

I created the following shortcut that users use to access the DB using their
assigned login and password:

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Unified Doers
Management Group\UD_Management Group.mdb" /WRKGRP "C:\Unified Doers
Management Group\Security.mdw"

Works fine.

However, the DB will open if they double-click <UD_Management Group.mdj>.
Which defeats the purpose of the user-level-security. How can I force the
login screen to appear when they double-click on <UD_Management Group.mdj>?

 

[Rick Brandt]

I created the following shortcut that users use to access the DB using
their assigned login and password:

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Unified
Doers Management Group\UD_Management Group.mdb" /WRKGRP "C:\Unified
Doers Management Group\Security.mdw"

Works fine.

However, the DB will open if they double-click <UD_Management
Group.mdj>. Which defeats the purpose of the user-level-security. How
can I force the login screen to appear when they double-click on
<UD_Management Group.mdj>?

Set up security correctly. If they can get in without logging into your
workgroup then you missed a step when you secured it. Most common is
leaving "Admin" as the owner of the database. Owners can get in even
when they have no permissions.