No Read Permission message

[bwlytkr]

Anyone know how to clear this issue. I get this message with any query I run associated with this table and can't find this table anywhere now. I no longer see tt in my relationship either. I tried deleting my import table and rebuild it but, I can't do that either. RAW_NJUNS is the name of my table. No issues in the past since I am the creator of the table and Queries.


Record(S) cannot read; no read permission on 'RAW_NJUNS'.

 

[Joe4]

If the table no longer exists, you are going to have problems with any Query, Form, Report, or Relationship that uses/references this table.
Was this a native table in Access, or a linked table?

If you do not need to use this table, you will need to remove it from all objects that reference it.

 

[bwlytkr]

If the table no longer exists, you are going to have problems with any Query, Form, Report, or Relationship that uses/references this table.
Was this a native table in Access, or a linked table?

If you do not need to use this table, you will need to remove it from all objects that reference it.

I Can't do this because I can't open the queries and I can't find the table anywhere so I can delete it. I assume it's hidden somewhere. Any ideas on how to locate the table if it's hidden.

 

[Joe4]

You still haven't answered my question about the type of table it is (linked or not).
I don't know how it would become hidden if you didn't knowingly hide it.
You should be able to open your query in Design View or SQL View to edit it.

 

[xenou]

There is an option to view hidden objects in the navigation pane. You could google for info on this and see if it helps (unlikely that someone else hid your table but then it isn't clear why you don't have permission anymore ... if it even exists). Also I'm curious if this is a linked table or native MSAccess table.

 

[bwlytkr]

Thanks for the info. I’ll check google to see how to access the hidden tables. Btw it is not a linked table and I cannot open the query in design view either. Another odd thing is when I pull up the relationship report it shows the table there but it doesn’t appear when I looked at all my relationships. Wierd