Forum Discussion

mokhc's avatar
mokhc
Copper Contributor
Jul 09, 2022
Solved

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 th...
access
  • mokhc's avatar
    mokhc
    Jul 13, 2022

    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.

mokhc's avatar
mokhc
Copper Contributor
Jul 12, 2022
I have deleted the system.mdw file but I still can't create a new database after that.
isladogs's avatar
isladogs
MVP
Jul 12, 2022
What happens now? Same error or something else?
Can you show screenshots of anything relevant to this issue
  • mokhc's avatar
    mokhc
    Copper Contributor
    Jul 12, 2022
    I have tried the deleting the system.mdw method but it does not work.

Resources