Access changes my query SQL
Hi all
ms Access 2003, SP2.
I write a SQL statement that unions some other queries and it works
ok. Then, if I save and close it and open the form that uses the query
as its data source, I get an error that the form can't find some parts
of the SQL that was in my query. I open the query again and find that
Access has changed my SQL, removing some of my code.
Whats up with that?
Is there some way to tell Access to leave my SQL code alone, it works
just fine as I wrote it?
Thanks
Jeff
.
Relevant Pages
- Re: Official Status of SQLServer 2005 ADP
... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
(microsoft.public.access.adp.sqlserver) - Re: "Query Too Complex" Errors
... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
(microsoft.public.access.forms) - Re: Dynamic query problem
... On Oct 17, 9:41 am, Andy Hull ... If we were to provide a fully featured dynamic query generator we would have ... Provided with already built queries which they can edit ... SQL and see where it is the same as for the other queries and where it ...
(microsoft.public.access.queries) - Re: CONTAINS performance
... mark, FTS needs to be very carefully tuned to achieve second response times, ... see SQL Server 2000 BOL title "Full-text Search Recommendations" for more ... When you include the "TOP 100" in your query, you are in fact limiting the ... valid for SQL queries, they often do not apply to FTS queries because the FT ...
(microsoft.public.sqlserver.fulltext) - Re: DBMS and lisp, etc.
... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
(comp.lang.lisp) |
|
