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

Access 2003 - Could Not read Definitions ; No Read Definitions

P: 36
So I've come across a complicated Paradox.
I am the owner and admin of Database A.
However, When I try to open this one certain table in Database A - I get the following :

Could Not Read Definitions; No read permissions for table....

So I checked the Tools - Security and that is the only Table where all Permissions were unchecked.

How could that happen?

The problem is , Now I can't get delete it or recreate it... or even Export it.. Since there are no permissions defined, Eventhough I AM the admin.
The Admin needs Admin permissions that he can't give himself.

Any Suggestions?
Jan 3 '08 #1
Share this Question
Share on Google+
2 Replies


patjones
Expert 100+
P: 931
So I've come across a complicated Paradox.
I am the owner and admin of Database A.
However, When I try to open this one certain table in Database A - I get the following :

Could Not Read Definitions; No read permissions for table....

So I checked the Tools - Security and that is the only Table where all Permissions were unchecked.

How could that happen?

The problem is , Now I can't get delete it or recreate it... or even Export it.. Since there are no permissions defined, Eventhough I AM the admin.
The Admin needs Admin permissions that he can't give himself.

Any Suggestions?
This is a shot in the dark, but have you tried opening the database while holding down the Shift key (keep it held down until the database is completely loaded). I do this a lot with databases that have already been converted to .accde format for instance; it might have an impact on what you can do with the permissions.

Just a thought...

Pat
Jan 3 '08 #2

P: 36
This is a shot in the dark, but have you tried opening the database while holding down the Shift key (keep it held down until the database is completely loaded). I do this a lot with databases that have already been converted to .accde format for instance; it might have an impact on what you can do with the permissions.

Just a thought...

Pat
I tried that as well.

In the end, I had to re-name the Table.

I still can't find the root cause for it's occurrence.
Jan 10 '08 #3

Post your reply

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