RE: Corrupt mdw file?

From: Eileen (anonymous_at_discussions.microsoft.com)
Date: 05/05/04


Date: Wed, 5 May 2004 05:59:17 -0700

Thanks Eric - I was able to restore the file from the
backups fortunately. Hopefully that will not occur again
but I will save your instructions just in case.
>-----Original Message-----
>Hi Eileen,
>
>Using Access 2002 or 2003:
>
> If you secured *.MDW file is the default
workgroup file
> - Click the menu option Tools >
Security > User and
>Group Accounts
> - Select the tab "Change Logon
Password" and give the
>Admin account a password
> - Click Ok and close Microsoft Access
> - Now try opening your secured
database file (should be
>prompted for User Name and Password)
>
> If you secured *.MDW file is NOT the default
workgroup file
> - Click the menu option Tools >
Security > WorkGroup
>Administration
> - Click the Join button to join to
your secured *.MDW
>file
> - Then follow the same steps as above
>
>If you are using Microsoft Access 2000 or lower then:
> - Create shortcut
> <full path to
MsAccess.exe> /wrkgrp <full path to
>your *.MDW file>
> - Double click on the newly created
shortcut
> - Once Microsoft Access is launched
select the menu
>option Tools > Security > User and Group Accounts
> - Select the tab "Change Logon
Password" and give the
>Admin account a password
> - Click Ok and close Microsoft Access
> - Now try opening your secured
database file (should be
>prompted for User Name and Password)
>
>IMPORTANT: if you are NOT pointing to the correct *.MDW
or it's NOT your
>default then you will be opening the secured *.MDB as the
Admin account
>
>I hope this helps! If you have additional questions on
this topic, please
>respond back to this posting.
>
>
>Regards,
>
>Eric Butts
>Microsoft Access Support
>ebutts@online.microsoft.com
>"Microsoft Security Announcement: Have you installed the
patch for
>Microsoft Security Bulletin MS03-026? If not Microsoft
strongly advises
>you to review the information at the following link
regarding Microsoft
>Security Bulletin MS03-026
><http://www.microsoft.com/security/security_bulletins/ms03
-026.asp> and/or
>to visit Windows Update at
<http://windowsupdate.microsoft.com/> to install
>the patch. Running the SCAN program from the Windows
Update site will help
>to insure you are current with all security patches, not
just MS03-026."
>
>This posting is provided "AS IS" with no warranties, and
confers no rights
>
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Eileen" <anonymous@discussions.microsoft.com>
>| Sender: "Eileen" <anonymous@discussions.microsoft.com>
>| Subject: Corrupt mdw file?
>| Date: Tue, 4 May 2004 14:25:23 -0700
>| Lines: 8
>| Message-ID: <861e01c4321e$4f1b8db0$a301280a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| Thread-Index: AcQyHk8blOjrmygiTV2dYeohiGajJQ==
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Newsgroups: microsoft.public.access.security
>| Path: cpmsftngxa10.phx.gbl
>| Xref: cpmsftngxa10.phx.gbl
microsoft.public.access.security:10465
>| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
>| X-Tomcat-NG: microsoft.public.access.security
>|
>| Hi
>| I inadvertantly cleared the "admin" password in my
secured
>| database. Now I am unable to logon to it (nor are the
>| other users able to). I get the error concerning
>| inadequate permissions.....Is there a way to fix this?
I
>| do have an older backup copy so all is not lost. Just
>| wonder if there is a way to restore that .mdw file.
>| Thanks.
>|
>
>.
>