By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,916 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,916 IT Pros & Developers. It's quick & easy.

How can I recover permission after a 3112 Error?

P: 2
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]
Sep 4 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,366
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.
Sep 4 '07 #2

puppydogbuddy
Expert 100+
P: 1,923
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
Sep 4 '07 #3

P: 2
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
Sep 4 '07 #4

Rabbit
Expert Mod 10K+
P: 12,366
Then it sounds like it indeed might be corruption and you should follow the steps that puppydogbuddy laid out.
Sep 4 '07 #5

Rabbit
Expert Mod 10K+
P: 12,366
Resuscribing .
Sep 5 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.