O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Upsizing Wizard

After you have prepared your desktop database for upsizing, you’re ready to run the Upsizing Wizard. Let’s take a look at upsizing the Contacts2Upsize.mdb sample database. The upsize process does not permanently alter the original database, but the wizard does create temporary objects in this database as it upsizes it. It creates a new project file that contains the converted forms, reports, macros, and modules; converts the tables and queries to an SQL Server database; and connects the new project to that database.

Ensuring That Your Server Is Started

Before you begin, you must be sure you can connect to an SQL Server database system that lets you create a new database and tables, views, and stored procedures in that database. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required