Welcome! and rules
Joel on Software
.NET data adapter rewrites my queries :-(
I am accessing an Access 2.0 database using a .NET data adapter.
kindly post your database connectivity & query code for us to review.
Indeed... OleDbDataAdapter, OdbcDataAdapter or what? It should be the former BTW.
I just thought -- don't use the graphical query designer then -- just copy and paste the Access SQL into the SQL textbox; you're using the DataAdapter Wizard aren't you? The graphical editor I think is really optimised (and primarily designed for) for SQL Server T-SQL -- so don't use it!
The SQL you write internally to access and the SQL you use through OLEDB are not necessarily going to be identical - and its entirely possible that what works in one case will not work in the other.
Fog Creek Home