security applied to all my DBs shanej2015[ at ]yahoo.com 08.07.2006 00:54:01 I setup security groups and users for a particular DB, now when I open any DB it requires that I login. I did not intend for that, and it will be a problem for other users with limited privileges. How can I use security for just a single DB rather than all DBs? Shane

Re: security applied to all my DBs "Joan Wild" <jwild[ at ]nospamtyenet.com> 08.07.2006 15:17:31 Hopefully you didn't set these up in your system.mdw workgroup; the first step is to create a new workgroup file. Anyway, the solution is to use the workgroup administrator to rejoin the system.mdw as your default. Access will use this mdw for all sessions of Access (no login). For your secure mdb, you can rejoin your secure mdw using the administrator (tedious), or create a desktop shortcut that points to your secure mdw. Using the shortcut will override the default for just that session. The target of the shortcut would have the following in it: "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw" -- Joan Wild Microsoft Access MVP shanej2015[ at ]yahoo.com wrote: [Quoted Text] > I setup security groups and users for a particular DB, now when I open > any DB it requires that I login. I did not intend for that, and it > will be a problem for other users with limited privileges. How can I > use security for just a single DB rather than all DBs? > > Shane

Re: security applied to all my DBs "shanej" <shanej2015[ at ]yahoo.com> 08.07.2006 17:28:45 What is the /wkgrp? Is that my workgroup or domain? ie "/myworkgroup" Joan Wild wrote: [Quoted Text] > Hopefully you didn't set these up in your system.mdw workgroup; the first > step is to create a new workgroup file. > > Anyway, the solution is to use the workgroup administrator to rejoin the > system.mdw as your default. > > Access will use this mdw for all sessions of Access (no login). > > For your secure mdb, you can rejoin your secure mdw using the administrator > (tedious), or create a desktop shortcut that points to your secure mdw. > Using the shortcut will override the default for just that session. The > target of the shortcut would have the following in it: > > "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw" > > > -- > Joan Wild > Microsoft Access MVP > > shanej2015[ at ]yahoo.com wrote: > > I setup security groups and users for a particular DB, now when I open > > any DB it requires that I login. I did not intend for that, and it > > will be a problem for other users with limited privileges. How can I > > use security for just a single DB rather than all DBs? > > > > Shane

Re: security applied to all my DBs "shanej" <shanej2015[ at ]yahoo.com> 08.07.2006 17:32:15 Nevermind, I got it. Thanks! shanej wrote: [Quoted Text] > What is the /wkgrp? Is that my workgroup or domain? ie "/myworkgroup" > > Joan Wild wrote: > > Hopefully you didn't set these up in your system.mdw workgroup; the first > > step is to create a new workgroup file. > > > > Anyway, the solution is to use the workgroup administrator to rejoin the > > system.mdw as your default. > > > > Access will use this mdw for all sessions of Access (no login). > > > > For your secure mdb, you can rejoin your secure mdw using the administrator > > (tedious), or create a desktop shortcut that points to your secure mdw. > > Using the shortcut will override the default for just that session. The > > target of the shortcut would have the following in it: > > > > "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw" > > > > > > -- > > Joan Wild > > Microsoft Access MVP > > > > shanej2015[ at ]yahoo.com wrote: > > > I setup security groups and users for a particular DB, now when I open > > > any DB it requires that I login. I did not intend for that, and it > > > will be a problem for other users with limited privileges. How can I > > > use security for just a single DB rather than all DBs? > > > > > > Shane

Re: security applied to all my DBs kincaidch 19.07.2006 18:59:02 I was having the same problem. Thank you so for posting this! I worked great! "Joan Wild" wrote: [Quoted Text] > Hopefully you didn't set these up in your system.mdw workgroup; the first > step is to create a new workgroup file. > > Anyway, the solution is to use the workgroup administrator to rejoin the > system.mdw as your default. > > Access will use this mdw for all sessions of Access (no login). > > For your secure mdb, you can rejoin your secure mdw using the administrator > (tedious), or create a desktop shortcut that points to your secure mdw. > Using the shortcut will override the default for just that session. The > target of the shortcut would have the following in it: > > "Path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw" > > > -- > Joan Wild > Microsoft Access MVP > > shanej2015[ at ]yahoo.com wrote: > > I setup security groups and users for a particular DB, now when I open > > any DB it requires that I login. I did not intend for that, and it > > will be a problem for other users with limited privileges. How can I > > use security for just a single DB rather than all DBs? > > > > Shane > > >