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?
Open Microsoft Access (the following procedure assumes that you are using Access2007).
Select Visual Basic from Database Tools.
Display Debug Window (Ctrl+G).
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)
You may select the Create Option to create a new System.mdw file.
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.