Forum Discussion

mokhc's avatar
mokhc
Copper Contributor
Jul 10, 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 13, 2022
After running the scrubber and reinstalling the program, I still can't create a new database.
mokhc's avatar
mokhc
Copper Contributor
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.

  • isladogs's avatar
    isladogs
    MVP
    Jul 13, 2022
    I believe that all you've done is made the problem 'go away' for this database.
    My belief is that hasn't solved the problem for future databases.
    • mokhc's avatar
      mokhc
      Copper Contributor
      Jul 14, 2022
      I have created three new databases and they are working fine.
      • isladogs's avatar
        isladogs
        MVP
        Jul 14, 2022
        OK. Glad you have a solution

Resources