Forum Discussion
Error message - could not open table 'msysaccounts' in the workgroup information file. (error 3173)
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.
Run this program, before installing another version of ms office.
- what does "did not work" means.
it does not Totally remove all traces of your previous Office installation?
try to run the "scrubber" again and use a Registry cleaner to extra clean your registry.- After running the scrubber and reinstalling the program, I still can't create a new database.
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.
- MSysAccounts is only used if you are still using the old user level security which isn't applicable with ACCDB files
- I do not have any knowledge about user security level. Can you elaborate more?
AS already mentioned, user level security was an optional feature in old MDB files but it was deprecated with the ACCDB file format introduced in Access 2007. I haven't used it in almost 15 years so I suggest you do a Bing/Google search to find out more
Try this link as a starting point:
How to Set, Manage or Remove User-Level Security from MDB File in Access 2010 (isunshare.com)
