Forum Discussion
Error message - could not open table 'msysaccounts' in the workgroup information file. (error 3173)
Dear Sir/Mdm,
I have this error message while trying to create a new database in Microsoft Access - could not open table 'msysaccounts' in the workgroup information file. (error 3173).
I have the Home Office 2019 before i install the Microsoft Access 2021.
The problem arises after i install the Microsoft 365 personal.
I have un-install and re-install the software but to no avail.
I found some information from other resources and have solved the problem by using these steps:
1. First, you need to locate the file system.mdw
2. Open the visual basic editor by using Ctrl plus G keys
3. Type DoCmd.RunCommand acCmdWorkgroupAdministrator at the immediate window
4. Browse for the file system.mdw at its location after selecting Join…
Thanks for trying to help.
- arnel_gpSteel Contributorthere is a downloadable "scrubber" (now named Microsoft Support and Recovery Assistant) for All windows installation, meaning totally uninstall and "clean" any trace of Office installation whether Click-To-run, etc.
Run this program, before installing another version of ms office.- mokhcCopper ContributorTried the scrubber but it does not work.
- MSysAccounts is only used if you are still using the old user level security which isn't applicable with ACCDB files