urjudo
asked on
Update query error message
Hi Experts,
I have a question about query. it was just happened. I was trying to run an update query and this query I have been using for a long time and never have any problems but today when I try to update a record#, it gave me an error message "Query " is corrupt" when I click help, it says "You have referenced an undefined query name, check the queries listed in the QueryDefs collection to make sure you reference a valid query name". I even create a new update query, it gave me the same error. does anyone know why and how to fix?
Thanks
I have a question about query. it was just happened. I was trying to run an update query and this query I have been using for a long time and never have any problems but today when I try to update a record#, it gave me an error message "Query " is corrupt" when I click help, it says "You have referenced an undefined query name, check the queries listed in the QueryDefs collection to make sure you reference a valid query name". I even create a new update query, it gave me the same error. does anyone know why and how to fix?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scroll to the bottom of the article for 2010+2013+2016
ASKER
Thank you!
ASKER
I'm using windows 7 not office 365