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.
--
Joan Wild
Microsoft Access MVP
"mimi" <(E-Mail Removed)> wrote in message
news:9d2701c35c2a$bd824980$(E-Mail Removed)...
> 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
|