How do I get the "login" window to appear in ACCESS?

[Guest]

I am working in a secured ACCESS data base. When I open the database on my
computer, I get a login window that asks for my name and password. However,
my coworkers do not get the login window when they open the database. As a
result, they are unable to access any of the forms contained within the
database. How can I get the login window to appear on their machines? We
all are working in the same version of ACCESS.

 

[Rick B]

They need to join the workgroup tht you used to secure your database.

Or, build a shortcut that includes the workgroup file so that when the
coworker opens the database, it will also use the appropriate workgroup.

 

[Rick Brandt]

I am working in a secured ACCESS data base. When I open the database
on my computer, I get a login window that asks for my name and
password. However, my coworkers do not get the login window when
they open the database. As a result, they are unable to access any
of the forms contained within the database. How can I get the login
window to appear on their machines? We all are working in the same
version of ACCESS.

The login prompt is controlled by the workgroup file being used, not the MDB
file being opened. You likely have the secured workgroup that you created
as your default workgroup whereas the others still have System.mdw as their
default.

Rather than changing their default, the recommended approach is to give them
shortcuts that open your file and specify a non-default workgroup as a
command line parameter.

"path to MSAccess.exe" /wrkgrp "path to MDW" "path to MDB"

By the way...the fact that they can open the file at all with the wrong
workgroup indicates that it is not secured properly. They should be getting
"Permissions denied" errors.