ACC97: "Can't Read" Error, Trying to Open MDE Containing Module
ID: Q170696
|
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
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.
- Start Microsoft Access and log on as an administrator.
- Open the MDE file, holding down the SHIFT key to prevent any AutoExec
macros from running.
- On the Tools menu, click Options, and then click the View tab. Make sure
the System Objects check box is selected.
- On the Tools menu, click Security, and then click User And Group
Permissions.
- In the User And Group Permissions dialog box, click Groups, and then
select Table in the Object Type combo box.
- In the User/Group name list box, select Users.
- In the Object Name list box, select MsysModules2.
- Select the following permissions for the table:
- Read Data
- Read Design
- Update Data
- Insert Data
- Delete Data
- Click OK to close the User And Group Permissions box. Your users should
now be able to open the MDE file.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.
MORE INFORMATIONSteps to Reproduce Problem
- Quit Microsoft Access if it is running, and then make a backup copy
of your System.mdw file.
- Using the Workgroup Administrator program, create and join a new
workgroup. Make note of the Name, Organization, and Workgroup ID
values used to create the new workgroup. These values are combined to
create the group Security ID (SID) for the Admins group.
NOTE: For information about creating a workgroup information file,
search the Help Index for "workgroup information files, creating."
- Start Microsoft Access and activate the logon process by assigning a
password for the Admin user.
- Create a new user and add the user to the Admins group.
- Create another user, but do not add this user to the Admins group.
- Quit and restart Microsoft Access, logging on as the user you created
in Step 4.
- Create a blank new database.
- Create a new module with any sample code.
- On the Tools menu, click Security, and then click User-Level Security
Wizard.
- In the User-Level Security Wizard, click OK to accept the default
settings. Click Yes to continue if you receive a warning about
removing Admin from the Admins group.
- In the Destination Database dialog box, click Save to accept the
default file name for the secured database.
- Click OK to the User-Level Security Wizard message that lets you know
the database has been secured.
- Open the secured version of the database.
- On the Tools menu, point to Database Utilities, and then click Make MDE
file. In the Save MDE As dialog box, click Save.
- Quit and restart Microsoft Access. This time log on as the user you
created in Step 5.
- Open the MDE file created in Step 14. Note that you receive the error
message mentioned in the "Symptoms" section.
REFERENCES
For more information about creating MDE files, search the Help Index for
"MDE files, and then "about MDE files."
Keywords : kberrmsg ScrtAdm ScrtPerm
Version : 97
Platform : WINDOWS
Issue type : kbbug
|