Access 03 front end with SQL Server 05 back end.

So far I've tried to create two Pass Through Queries with a front end (my first attempts) The simple one worked and the complicated one didn't.

I'm guessing this is because I designed them in the Access Query Editor and then translated them using the pass through query option within the Access editor. I'm guessing that automatic conversion isn't perfect and the conversion may not work for more complicated queries.(I know access SQL and TSQL have differing flavours)

Is this correct? That realistically you should be only using the pass through conversion as an intial conversion after which you need to go in and edit the access SQL to tidy it up into a T SQL format for passing to SQL Server.

(I have no relationships in the back end)

Some Access functions don't work in SQL Server.

The biggest difference is the way dates are provided with single quotes instead of the hash. Also note that Access 2007 and before does not properly understand the new "DateTime" format in SQL Server 2008.