Software·43,882 discussions

No Read Permissions MSysAccessObjects

Locked

How can I change or read the No Read Permisions message that appears when the database will not open.
When attempting to open the file Paging Customer.mdb the following message pops up:
NoRead Permissions MSysAccessObjects.
How do we go about solving this problem.
OS is Windows 2000, Professional Office 2000 Professional.

Topic

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

Y’know, I did some *light* testing on this with your previous post, but was never able to “break in” to the database I removed the permissions on.

I’ll try more fiddling this weekend, but you need to prepare for the eventuality that you’re not going to be able to get in — sorry.

Do you have backups? If so, what is the level of effort to recover — really it may be shorter than finding a back door.

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

BTW, (I just went back and read the other — closed — thread) I do know what the problem is, it’s correcting it that I’m unable to provide you and answer with.

Access keeps certain information about your database in hidden system files. One of those files, MSysAccessObjects, has had its read permissions removed.

The problem is that in order to enable the permissions once again requires the database be opened — kind of like locking your keys in the car.

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

Thanks we do have backup 1 Mo ago busy durring XmAs with new builds & repairsPlan to do daily backup @ 4PM each day now. Any hints on runing this from server NT 4.0 with MS WIn 2000 Pro workstations. File is now run from WS.

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

As mentioned in an e-mail I just sent you, I have successfully opened my *test* database using DAO 3.60. I need a response to the questions I asked about your workgroup information file.

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

Poster rated this answer

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

This answer assumes you have Administer permissions on the database. If you do not enter a password upon opening the database, you should be logged in as the Admin user and have Administer permissions. If you do enter a password upon opening the database, you should login using an ID that has Administer permissions (or see your System Administrator to make these changes).

These instructions are for Access ’97, but should be the same/similar for Access/Office 2000:
1. Open the database.
2. On the Tools menu, select Options.
3. Select the View tab and Check the box next to System Objects and click on the Ok button.
4. On the Tools menu, select Security, User and Group Permissions.
5. Select the Group or User you want to have accessto the database (preferrably Group).
6. Select Table as the Object Type (drop-down box on the right side of the window below the Object Names).
7. Select the MSysAccessObjects table.
8. Click on the box next to Read Data.
9. Click on the Apply button.
10. After clicking on the Apply button, click on the Ok button.
11. On the Tools menu, select Options.
12. Select the View tab and Uncheck the box next to System Objects. Then click on the Ok button.

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

Poster rated this answer

No Read Permissions MSysAccessObjects

In reply to No Read Permissions MSysAccessObjects

This question was closed by the author

[Author]

Replies