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.

Thanks,

George


george

George,

Look in the Upsizing wizard report for the queries that failed. You will need to create appropriate udfs by hand.


David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

"failure to upsized" should be expected with that wizard for anything that is not ultra simple. I suggest not using the wizard and doing it yourself. In the end this will likely save your time.