How can I recover permission after a 3112 Error?

[Dave Maskalick]

Hello,

I am operating a Windows XP Professional system and when I open the MS Access 2000 database I created I now receive the following message:
“Record(s) cannot be read; no read permission on ‘Switchboard Items’.”
Then when I try to open a table I receive the following message:
“Could not read definitions: No read definitions permissions for table or query…”
Then when I open User and Group Permissions from the Security Selection in the Tools Menu I see that Admin no longer has any permission.
So I click on all the administer permission which selects all permissions and whether I click OK or Apply I receive the following message:
You can’t change permissions for “ItemName.”
To change permissions for this object, you must have Administer permission for it. For more information on permissions and who can set them, click Help.
Since I am sole user of this computer and this database I am the Administrator and I do not know how to proceed from here.
How can I correct this situation?

Dave Maskalick
[e-mail deleted]

[Rabbit]

Check what workgroup you're joined to, if it's not the default workgroup, rejoin the default workgroup. Usually named system.mdw. If you are in system.mdw, create a new workgroup and join the new one.

[puppydogbuddy]

Hello,

I am operating a Windows XP Professional system and when I open the MS Access 2000 database I created I now receive the following message:
“Record(s) cannot be read; no read permission on ‘Switchboard Items’.”
Then when I try to open a table I receive the following message:
“Could not read definitions: No read definitions permissions for table or query…”
Then when I open User and Group Permissions from the Security Selection in the Tools Menu I see that Admin no longer has any permission.
So I click on all the administer permission which selects all permissions and whether I click OK or Apply I receive the following message:
You can’t change permissions for “ItemName.”
To change permissions for this object, you must have Administer permission for it. For more information on permissions and who can set them, click Help.
Since I am sole user of this computer and this database I am the Administrator and I do not know how to proceed from here.
How can I correct this situation?

Dave Maskalick
[e-mail deleted]

The 3112 error is listed as symptom #6 in the list of symptoms of database corruption. You should proceed as if your file could be corrupted and perform the usual procedures that are used in such cases, starting with a repair and compact of the database, then followup with a decompile if the repair and compact did not work........and so on as prescribed in the links below:

http://granite.ab.ca/access/corruption/symptoms.htm

http://allenbrowne.com/ser-47.html

http://allenbrowne.com/ser-25.html

[Dave Maskalick]

Check what workgroup you're joined to, if it's not the default workgroup, rejoin the default workgroup. Usually named system.mdw. If you are in system.mdw, create a new workgroup and join the new one.

Rabitt,

Thanks for your reply. I do not know how to check to which work group I am joined or how to change it. I have created about a dozen system.mdw files now wityh no success. I have found old system.wdw files and after opening them I have tried to open this particular database or any archivewd copies of it, or any new copies I make of it, but, continue to get the same error message. I can open other databases I have stored on my computer but not htis particular one.

Any advice will be most appreciated!!!

Thanks again for your reply,

Dave

[Rabbit]

Then it sounds like it indeed might be corruption and you should follow the steps that puppydogbuddy laid out.

[Rabbit]

Resuscribing .