Security Wizard

[Guest]

I am using Access 2003. I have followed the steps completely as outline in
the installation instructions. However, it only works on one computer. If a
user enter the database from another computer, they are not prompted for a
logon or password. It seems there default system.mdw is being used rather
that the new user group i created. Please help!

 

[Joseph Meehan]

I am using Access 2003. I have followed the steps completely as
outline in the installation instructions. However, it only works on
one computer. If a user enter the database from another computer,
they are not prompted for a logon or password. It seems there default
system.mdw is being used rather that the new user group i created.
Please help!

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.