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.

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 B



"dj" <(E-Mail Removed)> wrote in message
news:2E36DA5D-30C5-4E84-86E8-(E-Mail Removed)...
>
> 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.

dj wrote:
> 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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com