Share this Page URL

Chapter 14. Understanding Access Project... > Upsizing an Access Database to SQL S... - Pg. 509

Understanding Access Projects 509 You'll notice that even though the tables are stored in a separate database, they don't show the linked table icon that you've seen in other chapters when we've worked with a standard Access database file. On your own, open one or more of the tables in this file in Design view. Notice the differences in how the columns are set up and in the list of data types. We'll describe these differences and others in the section "Creating SQL Server Tables in an Access Project," later in this chapter. Before we do that, we'll describe how you create an Access project from scratch and how to create an Access project using data in a SQL Server database that's already set up. Just the Steps Upsize an Access database 1. 2. 3. 4. Open the Access database you want to upsize. On the Tools menu, click Database Utilities, Upsizing Wizard. Follow the wizard's screens to select which tables you want to include in the upsized database, which table properties you want to convert, and the type of file to create. In the wizard's last screen, click Finish. Print or export the Upsizing Wizard Report, and then close the Report Preview window. You'll see the Database window for the new database. Quick Check Q. What are two reasons to consider upsizing an Access database to a SQL Server database? A. Size and security. An Access database has a size limit of 2 GB. A SQL Server database can store a much larger amount of data. A SQL Server database can be integrated with the security system provided by Windows.