I have a DB with a DB password. I have not implemented user level security in my database but one of my users tries to open the database and is prompted for a username and password. He is part of a workgroup for another database though and I believe that may be what is causing this issue. I have read here that if a password is set for the admin then this will be required for unsecured databases. Could this be the problem and if so how do I open my database without having to go to the individual who setup the workgroup?
Question Login on unsecured DB
- Thread starter Gannet
- Start date
statsman
Active member
- Local time
- Today, 18:19
- Joined
- Aug 22, 2004
- Messages
- 2,082
Bear with me on this:
When a database is "secured" using Group or User Security, the Security settings are saved in a file with the extension .mdw.
The default file is System.mdw which normally resides in your C:Windows folder.
If the security settings for your user's secured database were saved in System.mdw, then all of the Access databases he uses will require a User and Password login even though they are not "secured" on anyone else's computer.
This sounds as though it may be the problem.
If it is, good luck. I have no idea how to fix it.
When a database is "secured" using Group or User Security, the Security settings are saved in a file with the extension .mdw.
The default file is System.mdw which normally resides in your C:Windows folder.
If the security settings for your user's secured database were saved in System.mdw, then all of the Access databases he uses will require a User and Password login even though they are not "secured" on anyone else's computer.
This sounds as though it may be the problem.
If it is, good luck. I have no idea how to fix it.
If statsman's assessment is spot on, the only fix is to replace system.mdw. If your co-worker has a working system.mdw, just copy it and place it in the same location then it should be back to normal.
BTW, path: C:\Documents and Settings\%user name%\Application Data\Microsoft\Access\System.mdw
BTW, path: C:\Documents and Settings\%user name%\Application Data\Microsoft\Access\System.mdw
Problem Solved
The user was part of a Workgroup that was saved on his computer but not the System.mdw file. There are only two databases in access that he was using (neither one secure). Since there was no need of the security file I had him Join back to the System.mdw file. Everything is working fine now.
Thanks for the help.
The user was part of a Workgroup that was saved on his computer but not the System.mdw file. There are only two databases in access that he was using (neither one secure). Since there was no need of the security file I had him Join back to the System.mdw file. Everything is working fine now.
Thanks for the help.
Similar threads
