Securing database with the wizard

[Guest]

I just secured my first database on a network using the wizard, everything
works fine except when I try to open a new database it asks for user name and
password. Is there anyway to de-activate this without losing my user-level
security on my secure database? When I open an unsecured database I don't
want to have to log on to it.

 

[Rick Brandt]

I just secured my first database on a network using the wizard, everything
works fine except when I try to open a new database it asks for user name and
password. Is there anyway to de-activate this without losing my user-level
security on my secure database? When I open an unsecured database I don't
want to have to log on to it.

There are two ways to stop the prompting. You can remove the password from the
Admin user. Of course doing this will cause all attempts to open the file to do
so AS the Admin user so you won't be able to get in unless you grant rights to
the Admin user in which case your file is no longer secured.

Better is to create a shortcut that you use for opening this particular file.
In that shortcut you can specify your secure workgroup file (this allows you to
leave your default as System.mdw), as well as the account name and password that
you normally use. Then the file will open without a prompt.

 

[Rick Brandt]

I realized after sending my first reply that I had misread your question. If
you want prompting only when you open the secured file and not always then you
need to change your default workgroup back to System.mdw and create a custom
shortcut for your secured app that specifies a different workgroup file as a
command line argument.

There is actually a question in the security wizard that would have resulted in
this setup had you answered it differently than you did.

 

[Guest]

thanks for the input, I guess I need to figure out how to make a special
shortcut to the secured file. Access works properly on my computer but when I
link another work station to the secured database they have to log in to all
Access databases.

 

[Rick Brandt]

thanks for the input, I guess I need to figure out how to make a special
shortcut to the secured file. Access works properly on my computer but when I
link another work station to the secured database they have to log in to all
Access databases.

Whether you are prompted or not has to do with your workgroup and NOT the file
you are opening. If those users are not prompted when they open local files,
they should not be prompted when they open your files.