Getting 'query does not exist' message but it does !

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query which I can run via Query, however, when I build an SQL string using the query and try to run it (via ADO connection), I get a message saying it does not exist
I tried renaming the query - same thing. I even tried creating a new query and copying in the query text - same thing. I ran a compact and repair - still get the error. All my other queries work, this is driving me crazy and has had me stuck for hours. Anyone got any ideas
 
How are you trying to run it? It's pretty difficult for any of us to offer
advice without seeing your code!

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



David said:
I have a query which I can run via Query, however, when I build an SQL
Click to expand...
string using the query and try to run it (via ADO connection), I get a
message saying it does not exist.
I tried renaming the query - same thing. I even tried creating a new query
Click to expand...
and copying in the query text - same thing. I ran a compact and repair -
still get the error. All my other queries work, this is driving me crazy and
has had me stuck for hours. Anyone got any ideas?
 
Back
Top