Results 1 to 6 of 6

Thread: No Read Permission message
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2012
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default No Read Permission message

    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'.

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,794
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: No Read Permission message

    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.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Jun 2012
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: No Read Permission message

    Quote Originally Posted by Joe4 View Post
    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.

  4. #4
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,794
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: No Read Permission message

    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.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  5. #5
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,474
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: No Read Permission message

    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.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  6. #6
    Board Regular
    Join Date
    Jun 2012
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: No Read Permission message

    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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •