Upsizing Issues, Access to SQL Server
I am upsizing a number of Access 2003 databases to SQL Server 2005 with Access Project front ends. Access Tables all upsize OK, some Queries upsize to SQL Views, some to SQL Functions and some get skipped completely. I have fixed up data type issues with Yes/No and Date/Time fields.
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.