Results 1 to 6 of 6
  1. #1
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126

    query name not recognized!!!

    Suddely my query is showing this. I have renamed it to no avail. Swwms like MemNav should not be a reserved word???



    Attachment 48066Attachment 48066

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    memNav (and for that matter MemberNav) are not reserved words. Perhaps whatever it is you are doing is not looking for a query but something else with that name - perhaps a form, report or function

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Check your field names. Apparently, this message can erroneously report that the query name is the problem when the problem is a field name.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    Quote Originally Posted by Micron View Post
    Check your field names. Apparently, this message can erroneously report that the query name is the problem when the problem is a field name.
    Field names are ok. I am going to assume access corrupted my query and I will recreate it.

  5. #5
    Synergy.ron@gmail.com is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Location
    washington
    Posts
    126
    That worked. What could have corrupted it?

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Impossible to say, really. Such things might make me be more diligent about having backup files though.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. OLE Server Isn't Recognized
    By Luvflt in forum Access
    Replies: 9
    Last Post: 07-08-2015, 08:00 AM
  2. Why blank fields are not recognized.
    By Luvflt in forum SQL Server
    Replies: 16
    Last Post: 04-08-2015, 11:54 AM
  3. Field Not Recognized
    By Rustin788 in forum Reports
    Replies: 1
    Last Post: 08-25-2014, 10:34 AM
  4. Loop or Array not recognized
    By dvgef2 in forum Forms
    Replies: 6
    Last Post: 05-31-2013, 08:37 AM
  5. New Record not recognized in my queries
    By Kimmcdt in forum Queries
    Replies: 6
    Last Post: 01-16-2010, 10:26 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums