On 6/21/07, Tim Roberts <[EMAIL PROTECTED]> wrote: > Can you see any pattern to the rows that are missing? The query seems > simple enough. >
Well there were a lot of old-style wildcards in the subqueries (using * instead of %). >From Access, the query is run using the sql-89-esque syntax. From adodb, the sql-92 style is expected. Hence the discrepency. > Don't know. As an experiment, you might try doing this with DAO instead > of ADODB. DAO is the native API for the Jet engine; it's quicker than > ADODB, but much less general. > Yep. DAO works fine and produces the correct results. It looks like this situation has only two solutions: 1) convert all your queries and your database to use sql-92 wildcards or 2) use the native DAO engine. Since I have tons of legacy queries to deal with, I opted for #1 Thanks for all your help! Here's some useful references on the topic: [1] http://msdn2.microsoft.com/en-us/library/aa140104(office.10).aspx [2] http://www.devguru.com/features/knowledge_base/A100219.html [3] http://office.microsoft.com/en-us/access/HA010345621033.aspx -- Matthew T. Perry http://www.perrygeo.net "You never change things by fighting the existing reality. To change something, build a new model that makes the existing model obsolete" - R. Buckminster Fuller _______________________________________________ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
