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

Preparing Your Desktop Database

In this section, you’ll learn about the various types of changes you’ll need to make to successfully convert your application from a desktop database (.mdb) to a project file (.adp) connected to SQL Server. If you plan to use the Upsizing Wizard, you must make some of the changes before you attempt to run the wizard. You can delay other changes until after you’ve imported or upsized all your objects.

General Upsizing Considerations

By default, the Upsizing Wizard ignores any hidden objects in your database when it upsizes your database. If you’re using Import, you won’t see any hidden objects in the list of objects to import. If you want all your objects to be upsized, make sure they are not marked as hidden in your ...

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