Access 2000 user-level security wizard

[mimi]

hi,

I am developing a database which i have done the security
by using user-level security wizard. the security works
fine while i use the database in my own computer so it
askes for username and password and everthings work fine
but when i take the database to another computer, an error
message comes up that i do not have permission to access
the database and it even does not give me the sign up
window. there is not any chance to log into the database
and when i took it back to my own PC, the security was
working fine.

I am developing a database that needs security but it will
be installed on different PCs.What i am doing wrong?
Please help me!
Thanks

 

[Joan Wild]

The fact that it doesn't work on other PCs suggests that you have secured it
properly.

What you need to do is also copy the mdw that you secured it with to the
other machines (or make it available to them on a server). Create a
shortcut to start the secure mdb. It's target would look like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

On your machine, you are likely joined by default to the secure mdw. You
can use the workgroup administrator (Start, Run, wrkgadm.exe) to rejoin the
default system.mdw (usually in the systems folder), and then use a shortcut
to start your secure mdb.