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.
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)
- Noted on the information.
The Access i am using is the latest so i can't understand why this legacy thing appears. Further, i am just trying to use Access 2021 to create a new database. These are the steps leading to the error message:
1. Click on Access icon to open the program.
2. Click on the icon "Blank database".
3. Click on the icon "Create".
4. The error message appears!- That seems very odd. Are you trying to create an ACCDB file or an MDB?
Check for the existence of a workgroup information file - normally called system.mdw.
If it exists - make a backup (just in case) then delete it ...if you can- It's accdb. I tried to delete the system.mdw file but it does not work.
