Share this Page URL

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

Understanding Access Projects 505 5. 6. 7. Select the option Use Trusted Connection. In a trusted connection, you'll access the SQL Server database with your Windows user name and password. As an alternative, you could set up a login ID and password for this database connection. Keep the database name the wizard provides, or enter a name of your choice, and then click Next. Move the tables you want to include in the SQL Server database to the Export To SQL Server list, as shown here. For this example, move all the tables, and then click Next again.