security.mdw from h drive to network

[RayNDM83]

Hi,
I am trying to set up a secured dbase in our network. I ran the security
wizard with the dbase on my H drive (my desktop on our network) and copied
them to our network drive (mdw, the shortcut and the file that i secured). My
problem is when I map myself to the security.mdw on our network drive, all
other access file that I open will also prompt me for the password. I know I
am missing something but canl't figure out what. I hope you could help me.
Thanks,
RayNDM83

 

[RayNDM83]

Thanks Cris, but I probably didn't explained it all and I am a bit novice
with this path (all one line) you instructed me to do. When I let the secured
db (FE) resides on my citrix h drive (my docs), I am not prompted for a
password if I will open up other acces file of ours. But if I copied my
secured db to our network and revise the target and start in boxes of my
shortcut, all other files I open will prompt me for my password (our access
program resides inside our citrix network and not in my hardrive). What I
will do next after I secured the dbase is to copy them (the FE) to a remote
computers and set up the users with different security level. Do I need to
run another security wizard on his/her computer? Or how do I make their
stations (computer) join the workgroup I created?
Thank you for your patience.
RayNDM83

 

[Keith Wilby]

Thanks Cris, but I probably didn't explained it all and I am a bit novice
with this path (all one line) you instructed me to do. When I let the
secured
db (FE) resides on my citrix h drive (my docs), I am not prompted for a
password if I will open up other acces file of ours. But if I copied my
secured db to our network and revise the target and start in boxes of my
shortcut, all other files I open will prompt me for my password (our
access
program resides inside our citrix network and not in my hardrive). What I
will do next after I secured the dbase is to copy them (the FE) to a
remote
computers and set up the users with different security level. Do I need to
run another security wizard on his/her computer? Or how do I make their
stations (computer) join the workgroup I created?
Thank you for your patience.
RayNDM83

The "classic" setup is this:

Back end file and workgroup file on a server in a public folder. Front end
file on each user's local drive with tables linked to the BE. All users,
including the developer (you), joined by default to the unmodified
"system.mdw" workgroup. All users, including the developer, use a desktop
shortcut to join the custom workgroup on a session by session basis. Such a
shortcut should have a target in the format

"full path to MSACCESS.EXE" "full path to your FE file.mdb" /wrkgrp "full
path to your custom workgroup file.mdw"

including the quotation marks. If you can open your "secured" db file
whilst joined to the default workgroup without using such a shortcut then it
is not properly secured at all.

If you need to troubleshoot user-level security then you need to understand
it and you will only understand it if you read and digest the FAQ (there's a
link to it on my web site).

HTH - Keith.
www.keithwilby.com

 

[RayNDM83]

Thanks to both of you guys. Databases are all working well.