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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
action query message 1
Form Filter should work, but it does not 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Select Query Broken 3
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Back
Top