Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lost SYSTEM.MDW (Access 2003 SP2)

    So I get a support call that a user had her computer replaced with a new one and now the Access DB she uses cannot launch because she is missing the SYSTEM.MDW file.

    We do not know where the original one is and she needs to get into the Database.

    I searched for this issue in this site but I came up with some links about converting MDA to MDW, or are recovering from an old MDW.

    This issue is for someone who has completely the MDW file.

    Can you help?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lost SYSTEM.MDW (Access 2003 SP2)

    If it's a secured .mdw file, and if there is no backup copy to be found, the only hope you have is that the strings used when creating the .mdw file have been stored somewhere - if so, you can recreate it. Otherwise, there's no (legal) way to get into the database anymore.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost SYSTEM.MDW (Access 2003 SP2)

    Thanks for the reply. I had a feeling about the "legal" way.

    Since I work for a big corp, they will have to suffer not having a backup... lol

    Thanks again

  4. #4
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lost SYSTEM.MDW (Access 2003 SP2)

    Ok. How about this?

    Is there a registry setting that can tell me what SYSTEM.MDW file it was using? Maybe it was on a network share so I need to hunt for it.

    Thanks

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lost SYSTEM.MDW (Access 2003 SP2)

    The registry contains the path to the default .mdw file for the user. However, it is possible to use a secured database in combination with a non-default .mdw file, by creating a shortcut that opens the database using a specific .mdw file. This is in fact the recommended setup.
    For what it's worth, the registry entry is the SystemDB value in HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0Access Jet4.0Engines.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •