Upsizing is the process of migrating some or all database objects from a Microsoft Access database (.mdb) to a new or existing Microsoft SQL Server database or new Microsoft Access project (.adp). This topic provides reference information about:
The Upsizing Wizard upsizes an Access database to a new or existing Microsoft SQL Server 6.5 and 7.0 database or new Access project by upsizing the data and data definitions, and migrating database objects. There are three ways to use the Upsizing Wizard:
Return to top
The Upsizing Wizard creates a report that provides a detailed description of all objects created, and reports any errors encountered during the process. The Upsizing Wizard automatically creates this report as a report snapshot with the same name as the Access database (for example, Northwind.snp), and stores it in the same folder.
The Upsizing Wizard report contains information about the following:
Return to top
Designing and building an optimized client/server application is different from designing and building an optimized file server application. Therefore, you probably need to retrofit your application to take full advantage of SQL Server and an Access project. After you upsize, you need to manually convert code from Data Access Objects (DAO) to ActiveX Data Objects (ADO) in your modules, and convert queries that did not upsize (such as those that were nested too deeply). For more information on developing optimized client/server applications, see the Microsoft Office 2000/Visual Basic Programmer's Guide
Return to top
Before you upsize a Microsoft Access database
Upsize your Microsoft Access database
Optimize Microsoft Access project performance
Return to top