|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
I tried assigning the security permissions to my database and now all my
access programs have the same security settings! I have Microsoft Access 2003 Bible and I can not find the answer in there. Don't panic. None of the other dbs are secured. You're being prompted for
user name and password because the workgroup you're joined to has a password assigned to the admin user. Join the default workgroup, system.mdw. You won't be prompted for the user name and password when you open dbs. Whenever you want to open a secure db, use a shortcut with this format (all one line): "path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw" Chris DevilDog1978 wrote: >I tried assigning the security permissions to my database and now all my >access programs have the same security settings! I have Microsoft Access 2003 >Bible and I can not find the answer in there. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200902/1 Ok well that makes me breathe a little easier. I am new to Access...could you
walk me through the steps you just described. I was unable to figure out how to do that. Show quoteHide quote "Chris O'C via AccessMonster.com" wrote: > Don't panic. None of the other dbs are secured. You're being prompted for > user name and password because the workgroup you're joined to has a password > assigned to the admin user. > > Join the default workgroup, system.mdw. You won't be prompted for the user > name and password when you open dbs. Whenever you want to open a secure db, > use a shortcut with this format (all one line): > > "path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw" > > Chris > > > DevilDog1978 wrote: > >I tried assigning the security permissions to my database and now all my > >access programs have the same security settings! I have Microsoft Access 2003 > >Bible and I can not find the answer in there. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200902/1 > > 1 - Search your hard drive for system.mdw. It's probably stored at C:\
Documents and Settings\username\Application Data\Microsoft\Access\system.mdw 2 - Open Access (not a db file, just Access) 3 - Tools > Security > Workgroup administrator 4 - Push the "join" button 5 - Browse to your system.mdw file you located in your search 6 - Push the ok button (3 times to accept each message) 7 - Close Access Now you shouldn't be prompted for user name and password when opening dbs unless you accidentally added a password to the admin user in the default workgroup. (In that case, remove the admin's password, it's not doing you any good. You would need to secure the db with a custom workgroup, not the default workgroup.) Test this by opening an unsecured db. For each secured db, make a shortcut and put the paths to msaccess.exe, your db file, the workgroup switch and the workgroup file in the shortcut's target. "path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw" Whenever you want to open an unsecure db, you double click the file name in Windows Explorer and it opens. Whenever you want to open a secure db, you double click the shortcut to it (so you temporarily join the secure workgroup for your session), and you'll be prompted for user name and password. Chris DevilDog1978 wrote: >Ok well that makes me breathe a little easier. I am new to Access...could you >walk me through the steps you just described. I was unable to figure out how >to do that. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200902/1 Thank you for your help. Now my next problem is I am trying to create user
accounts with passwords to access the database. I did the one step security wizard. When I put the database onto the shared drive, everyone has access to the program without the use of a password. I want multiple people to be able to access the database at once and I have been unable to do that. Show quoteHide quote "Chris O'C via AccessMonster.com" wrote: > 1 - Search your hard drive for system.mdw. It's probably stored at C:\ > Documents and Settings\username\Application Data\Microsoft\Access\system.mdw > > 2 - Open Access (not a db file, just Access) > 3 - Tools > Security > Workgroup administrator > 4 - Push the "join" button > 5 - Browse to your system.mdw file you located in your search > 6 - Push the ok button (3 times to accept each message) > 7 - Close Access > > Now you shouldn't be prompted for user name and password when opening dbs > unless you accidentally added a password to the admin user in the default > workgroup. (In that case, remove the admin's password, it's not doing you > any good. You would need to secure the db with a custom workgroup, not the > default workgroup.) > > Test this by opening an unsecured db. > > For each secured db, make a shortcut and put the paths to msaccess.exe, your > db file, the workgroup switch and the workgroup file in the shortcut's target. > > > "path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw" > > Whenever you want to open an unsecure db, you double click the file name in > Windows Explorer and it opens. Whenever you want to open a secure db, you > double click the shortcut to it (so you temporarily join the secure workgroup > for your session), and you'll be prompted for user name and password. > > Chris > > > DevilDog1978 wrote: > >Ok well that makes me breathe a little easier. I am new to Access...could you > >walk me through the steps you just described. I was unable to figure out how > >to do that. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200902/1 > > It's not secured properly. You missed some steps. Read and study the
security faq, practice on a copy of the db, and then secure the db when you're ready. http://support.microsoft.com/?id=207793 Chris DevilDog1978 wrote: >When I put the database onto the shared drive, everyone has access to >the program without the use of a password. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200902/1  
Other interesting topics
type mismatch and allowbypasskey
.mdb file is read only... expressions blocked inconsistently Multi-User input and db protection Shortcut needs to work in a Domain instead of a workgroup Access cannot open file on stand alone computer I cannot open a DB created by another user on my PC. help understanding mdw files! AllowBypassKey and Type Mismatch Error How to hide table using User-Level Security |
|||||||||||||||||||||||
