home

Records Can't Be Read; No Read Permissions on MsysModules2

Derived from Microsoft Knowledge Base Article 170696. February 28th 2003.
The information in this article applies to Microsoft Access 97

Problem
When you open an MDE file that was created from a secured database that contains modules, you may receive the following error message:

Record(s) can't be read; no read permissions on 'MsysModules2'

Cause
This problem occurs because only the owner of the MDE file or a member of the Admins group when the MDE file was created can successfully open an MDE file created from a secured database that contains modules.

Resolution
The following workaround allows your users to open the database. This workaround assumes that the database is secured, the MDE file has already been created, and you are currently using the workgroup file that was used when the MDE file was created.

  1. Start Microsoft Access and log on as an administrator.
  2. Open the MDE file, holding down the SHIFT key to prevent any AutoExec macros from running.
  3. On the Tools menu, click Options, and then click the View tab. Make sure the System Objects check box is selected.
  4. On the Tools menu, click Security, and then click User And Group Permissions.
  5. In the User And Group Permissions dialog box, click Groups, and then select Table in the Object Type combo box.
  6. In the User/Group name list box, select Users.
  7. In the Object Name list box, select MsysModules2.
  8. Select the following permissions for the table:
    • Read Data
    • Read Design
    • Update Data
    • Insert Data
    • Delete Data
  9. Click OK to close the User And Group Permissions box. Your users should now be able to open the MDE file.