| 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 |
Upsizing Access to SQL Server 2005
Hot Topic
- try to setup membership with ASP.NET configuration
- How to optimize data import with huge volumes and joins across data sources not all SQL Server based?
- What happend to the stored procedure wizard
- Can I use AMO from .net 2003?
- Matrix not displaying null fields
- DISTINCT Conflicting with my query
- Could not load file or assembly 'System.Data.SqlServerCe'...
- Reporting Services 2005 and XML DataSource (as WebService)
- debugger doesn't stop at breakpoint while debugging SQLCLR function
- SQL Server Integration Services (Standard vs Enterprise Editions)
SQL Server
- Data Warehouse Presentation
- Report Model in VM environment
- Notification Services & Triggers
- Distinct Count in a new Measure Group
- Restored Database/Diagrams Support/SQL-Server 2005
- SQL Error
- How can I skip an initialize snapshot?
- Print reports is very slow
- VS 2005and SQLserver Express intergration
- Question about dataasource and the .rdl file and the .rdl.data
Upsizing Access to SQL Server 2005
tonante
I think the best place to start is from the Access side as there may be limitations or known issues with the Wizard, so I would go post in the Access forum. I did see the following white paper though it looks a bit outdated.
http://support.microsoft.com/kb/175619/en-us
Hope that helps
Nate Dogg
Thanks Craig.
I have overcome most of the issues with a not inconsiderable amount of work.. The Access sides need preparation prior to using the upsizing wizard as you suggest.
Regards
RossDonald
George
Have you considered using an Access MDB as a Front-End to SQL Server
This way you can continue to use all your Select Queries, including all your calculated fields.
Action Queries need special attention, but can be converted to Stored Procedures with a bit of foresight..
I don't yet know SQL Server 2005, but for SQL Server 2000 a "traditional" Access front-end seems to be an attractive option where you have put a lot of effort into developing an Access application.
Dave White