System.mdw missing (1 Viewer)

KenHigg

Registered User
Local time
Today, 13:30
Joined
Jun 9, 2004
Messages
13,327
Hi all - long time :)
I am trying to open an accdb on a new Win10 install and it says it can't find the system.mdw. I've tried everything I can think of and can't get past this. Anyone have any suggestions?
 

KenHigg

Registered User
Local time
Today, 13:30
Joined
Jun 9, 2004
Messages
13,327
Thanks - I'll give them a try. I am trying to do this on a imac/VMware...
 

KenHigg

Registered User
Local time
Today, 13:30
Joined
Jun 9, 2004
Messages
13,327
It won't let me even create a blank database now... ugh. I'm stuck.

A second dialog pops up saying to quit the ole server. I can't find out how to do that ....
 

KenHigg

Registered User
Local time
Today, 13:30
Joined
Jun 9, 2004
Messages
13,327
Thanks Doc - I'll give that a try.
 

apr pillai

AWF VIP
Local time
Today, 23:00
Joined
Jan 20, 2005
Messages
735
To create System.mdw file do the following:
  1. Open Microsoft Access (the following procedure assumes that you are using Access2007).
  2. Select Visual Basic from Database Tools.
  3. Display Debug Window (Ctrl+G).
  4. Copy and paste the following Command and press Enter Key:
    Code:
    DoCmd.RunCommand acCmdWorkgroupAdministrator
    A Control Box will appear with the existing System.mdw (or whatever file was in use) file details:
    a) Name: xxxxxx
    b) company: xxxxxx
    c) C:\folder\folder\system.mdw (note down this location to save your .mdw file)
    Option Buttons:
    a) Create (create a new .mdw file)
    b) Join (join an existing .mdw file)
  5. You may select the Create Option to create a new System.mdw file.
  6. Or select Join to select an existing .mdw file, from it's known location and click OK.
Note: By creating a System.mdw with random information for Name, Compay may not work for you because the database you are trying to open is already aware of a System.mdw file (or expects) with specific Name, Company information because these two informations are part of the User-level Security token (http://msaccess-tips.blogspot.com/2011/10/access-security-key-diagram.html.
 
Last edited:

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 12:30
Joined
Feb 28, 2001
Messages
26,999
Knew about the presence of the Name/Company info; did not realize there was a DoCmd option for that utility.

Thanks, apr pillai!
 

Users who are viewing this thread

Top Bottom