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
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