Upsizing Issues, Access to SQL Server

[gvcooper]

I am upsizing a number of Access 2003 databases to SQL Server 2005 with Access Project front ends.

My Access Tables all upsize OK,
Some of the Queries upsize to SQL Views OK,
Some Queries upsize to SQL Functions (WHY) and some get skipped completely.

I have fixed up data type issues with Yes/No and Date/Time fields.

It seems that queries with Calculated Fields are a problem.

I would like all my Access Queries to be SQL Views. Some queries may have calculated fields and I suspect this is one of the issues. The only log in the report states 'Query "QueryName" failed to upsize'.

Where should I start looking. Any ideas on this please.

Thanks,

George

 

[pbaldy]

I would start by looking at the SQL of the queries. My guess is that they contain functions that SQL Server does not understand, such as IIf, Format, etc. Can you post the SQL of one of the offending queries?