[mso] Re: password prompts in Access

  • From: Thomas Hutchins <hutch99999@xxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Wed, 3 May 2006 09:50:00 -0700 (PDT)

I believe this is related to the MDW file your database is linked to. Every 
database must be linked to an MDW file (even if it is just to specify that 
there is unrestricted access to all users).
   
  It sounds like someone has modifed the default workgroup file (system.mdw) or 
used the workgroup admin tool to point Access to a custom MDW file. You need to 
link your database to the the standard system.mdw that ships with Access.  It 
is usually found in the windows system folder, or maybe C:\Documents and 
Settings\YourUserName\Application Data\Microsoft\Access.
   
  Use the workgroup admin tool to point Access back to the default system.mdw 
file. If you are using Access 2003 on Windows XP, you can try deleting (or 
renaming) system.mdw; Access should create a new and unmodified one for you.
   
  Other steps to try:
1. Log in as Admin user 
2. Add the Admin User to the Admins Group
3. Give the Users Group full permissions to all objects in the database
4. Remove the Admin user?s password 
5. Join to a ?clean? System.mdw (the one that shipped with Access)
   
  Hope this helps,
   
  Hutch
Don Goguen <dongoguen@xxxxxxxxx> wrote:
  In MS Access, has anyone run into the situation where no matter what you do 
(including a full fresh Office install), trying to create a new database or 
open an MDB that is not password protected in Access results in a password 
prompt for no apparent reason? Sure seems to be related to the instance of 
Access and not an MDB file...

I remember this from a few versions (and PCs) ago and found something about 
deleting a registry key or three at the time, but cannot seem to find mention 
of that any more (nor can I figure out which keys they were)......

- Don

---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ 
countries) for 2¢/min or less.

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top. This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions. Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************


                
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates 
starting at 1&cent;/min.

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: