I am trying to put workgroup security on one database application, but when I open other database apps they use the same security. I have the database I want to secure on the network and the security file, but it still affects other databases. Is there a way to only apply security to one database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Workgroup Security in Access
- Thread starter Prog76
- Start date
FancyPrairie
Programmer
I think what happen was that you, inadvertantly (via the wizard) set your newly created workspace as your default workspace. To determine this you should be able to run regedit. To run regedit, on the task bar select Start | Run and type in regedit. Then search for the name of your newly created workgroup file. (On my machine I find it under HKEY_LOCAL_MACHINE | SOFTWARE |Microsoft |Office | 9.0 | Access | Jet | 4.0 | Engines). If you find it, that's your problem. Change the key so it points to \\path\System.mdw (where path is the path where your System.mdw file resides)
In the future, I would suggest backing up the System.mdw file prior to creating new workgroups. Just in case you mess up.
In the future, I would suggest backing up the System.mdw file prior to creating new workgroups. Just in case you mess up.
- Thread starter
- #3
you can create a shortcut to the db you want to secure with a certain workgroup and use the following as the target:
"fullpath\MSACCESS.EXE" "fullpath\your.MDB" /wrkgrp "fullpath\wkgrp.MDW"
you must use the fullpath for all parts....
this will open the database with the named workgroup and then put you back on the default when you close the database.
****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
"fullpath\MSACCESS.EXE" "fullpath\your.MDB" /wrkgrp "fullpath\wkgrp.MDW"
you must use the fullpath for all parts....
this will open the database with the named workgroup and then put you back on the default when you close the database.
****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
FancyPrairie
Programmer
If you didn't use the wizard to create a "new" workgroup file, then I'm assuming that you simply selected Tools | Security | ... If so, then you modified the System.mdw file which ships with Access. And, since this is the default, every db you open will be using the same security. I would start over by copying the system.mdw file from you installation disk. Then use the wizard to create a new workgroup file. It's not difficult once you figure it out. However, figuring it out is time consuming. I can give you directions if you need them.
- Thread starter
- #6
Are you getting any errors? What exactly is not working?
****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
- Thread starter
- #8
Did you create your new workgroup using WRKGADM.EXE? If so, then it joined you to that workgroup.
All you need to do it open WRKGADM.EXE and join "system.mdw" - then your unsecured databases will use that workgroup. To get into the secured database, use a shortcut to point you to the correct .mdw file. Here's an example I use to open a database including my workgroup file, user name, and password (with the good stuff XXXX'd out, of course):
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "N:\New Database\New Database" /WRKGRP "n:\new database\PRODUCTION.MDW" /USER "XXXXX" /PWD "XXXXX"
Substitute your names in place of mine, and it should work.
All you need to do it open WRKGADM.EXE and join "system.mdw" - then your unsecured databases will use that workgroup. To get into the secured database, use a shortcut to point you to the correct .mdw file. Here's an example I use to open a database including my workgroup file, user name, and password (with the good stuff XXXX'd out, of course):
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "N:\New Database\New Database" /WRKGRP "n:\new database\PRODUCTION.MDW" /USER "XXXXX" /PWD "XXXXX"
Substitute your names in place of mine, and it should work.
GDGarth is spot on, and all these folks know of what they speak, but if you want to really understand this stuff...
Get the Faq. Read the Faq. Obey the Faq.
The Security FAQ from MS will answer any qeustions you have about this stuff. You can get it from them. There's also a copy on my website.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
Get the Faq. Read the Faq. Obey the Faq.
The Security FAQ from MS will answer any qeustions you have about this stuff. You can get it from them. There's also a copy on my website.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Thread starter
- #11
- Status
Similar threads
- Locked
- Question
- Locked
- Question