O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

The Upsizing Wizard

To use the Upsizing Wizard, open the mdb database that you want to convert and then call the Wizard from the Tools menus by selecting Database Utilities, then Upsizing Wizard. In the first dialog box, select whether you want to create a new SQL Server database or use an existing database.

Creating a New Database

In the next step, select the SQL server to which the database is to be saved. If you are using MSDE, this will probably be your own computer. SQL Server and MSDE have their own security system, described in detail in Chapter 20, “Security.” This system regulates access to SQL Server/MSDE and the rights for users and user groups to the databases. If SQL Server or MSDE are installed on a Microsoft Windows NT or Microsoft ...

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