Usizing issue Access to SQL Server
I am upsizing a number of reasonably large Access 2003 databases to SQL Server 2005 and using Access Project front ends. The code modules will stay with the front end. I have fixed up the data type issues (like Yes/No and date/time). I can upsize all Tables OK but some queries upsize to SQL Views, some upsize to Functions and some get skipped completely.
Does anyone know the likely causes. What can I look for in the queries that fail to upsize? Some of the queries may have calulated fields which may not have correct syntax for SQL but I can manage these manually if I have to. However some other Queries get skipped with the log "query failed to upsize" for no apparent reason.