"Chris O'C via AccessMonster.com" wrote:

> Make it easy on yourself.  Rejoin the default workgroup (named system.mdw)
> and use a shortcut for each secured db (all one line):
>
> "path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw"
>
> Any time you open a normal Access db, you aren't prompted for user name and
> password.  Any time you need to open a secure db, you use the shortcut, which
> will prompt you for your user name and password.
>
> Chris
> Microsoft MVP
>
>
> RayNDM83 wrote:
> >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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200809/1
>
>

"RayNDM83" <RayND***@discussions.microsoft.com> wrote in message
news:F6AC1BB1-63FD-4867-A5EF-32C8086C9E42@microsoft.com...
> 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" wrote:

> "RayNDM83" <RayND***@discussions.microsoft.com> wrote in message
> news:F6AC1BB1-63FD-4867-A5EF-32C8086C9E42@microsoft.com...
> > 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
>
>