Choose to upsize to an existing database or new database

Use existing database

If you select Use existing database, Microsoft Access displays the ODBC Select Data Source dialog box so you can create an ODBC connection to the existing Microsoft SQL Server database. For more information about ODBC data sources, Press Help.

Create new database

If you select Create new database, Microsoft Access displays the Microsoft SQL Server Database Wizard. Follow the instructions in the SQL Server Database Wizard.

What SQL Server would you like to use for this database? Type the name of the server you would like to use.

Use Trusted Connection You can use a trusted connection, that is, SQL Server can integrate with the Windows 2000 operating system security to provide a single log on to the network and the database.

Login ID and Password If you don't use a trusted connection, type the logon ID and password of an account with CREATE DATABASE privileges on the server.

What do you want to name your new SQL Server database? Type the name of the new SQL Server database. Access revises the name if it conflicts with an existing database name and adds a numbered suffix (mydatabase 1, for example).