Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
Upsizing Wizard in Access 2002, Access 2003 or Access 2007 database results in message when attempting to upsize to SQL Server 2008
When you use the Upsizing Wizard to attempt to create a new database on Microsoft SQL Server 2008 from Microsoft Office Access 2002, Microsoft Office Access 2003, sor Microsoft Office Access 2007 you will receive one of the following messages:
The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please Log into a SQL Server data source.
The Upsizing Wizard does not work with the version of Microsoft SQL Server to which your Access project is connected. See the Microsoft Office Update Web site for the latest information and downloads.
Microsoft Office Access 2002, 2003, 2007 and earlier versions were released before Microsoft SQL Server 2008. Those versions were not designed to support the use of the Upsizing Wizard in SQL Server 2008.
Upgrade to Microsoft SQL Server 2008 R2. Changes were made in Microsoft SQL Server R2 that allow upsizing Access databases.
Create a new database in Microsoft SQL Server 2008 and use the SQL Server Import and Export Wizard to import the Microsoft Access tables into the new SQL Server Database.
Microsoft Office Access 2002, 2003, and 2007 were released before Microsoft SQL Server 2008 was designed. Therefore, Office Access 2002, 2003 and Access 2007 were not designed to support the use of graphical design tools when an Access project is connected to a SQL Server 2008 database. See Microsoft Knowledge Base article 917418
Steps to reproduce
- In Microsoft Access 2003, create the Nothwind database from the help menu.
- On the Database Tools tab click SQL Server.
- Select Create new database and click Next
- Enter the name of your Microsoft SQL Server 2008
- Select Use Trusted Connection or enter your Login ID and Password
- Enter a name for the database, for instance "SQL Assets Template"
- Click Next
for other considerations.
Article ID: 2012792 - Last Review: June 14, 2010 - Revision: 1.0
- Microsoft Access 2002 Standard Edition
- Microsoft Office Access 2003
- Microsoft Office Access 2007
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate