Securing database with the wizard

E

ExDeltamech

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.
 
R

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.
 
E

Exdeltamech

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.
 
R

Rick Brandt

Exdeltamech said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top