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

D

David

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
 
D

Douglas J. Steele

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?
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
I can create Publisher documents, but I can not open / read them. 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
'Query does not exist' message but it does !?! 0
Using Query Defs in a Form 3
"Compile error in table level validation expression " after format 0

Top