Create an Access project
Click the Microsoft Office Button Button image, and then click New.
Alternatively, on the Getting Started with Microsoft Office Access page, under New Blank Database, click Blank Database.
Do one of the following:
Create an Access project in the default file location
Under Blank Database, type a name for the project in the File Name box using the .adp file name extension.
Create an Access project in a different file location
Under Blank Database, click Browse Button image for a location in which to save your database.
In the File New Database dialog box, browse to the location where you want to save the project, or accept the default location.
Type a file name for the project in the File name box.
In the Save as type list, select Microsoft Office Access Projects (*.adp), and then click OK.
Under New Project, click Create.
Access prompts you with the following message:
Do you want to connect to an existing SQL Server database?
If you want to connect to an existing SQL Server database, click Yes and continue with step 4; otherwise, click No and skip to step 5 to create a new SQL Server database.
Connect to an existing SQL Server database
In the Data Link Properties dialog box, enter the required information for the following:
Information needed to log on to the server
Data Link Properties dialog box
Click Test Connection to verify that the settings are correct and that the connection succeeds.
If the connection does not succeed, the Microsoft Data Link Error dialog box displays a message describing the problem. Click OK to close the message, check your settings in the Data Link Properties dialog box, and then click Test Connection again. Also, you might need to check with the SQL Server database administrator for the database you are connecting to, to make sure your settings are correct or that the computer is available.
After the Microsoft Data Link dialog box displays the message Test connection succeeded, click OK to close the dialog box, and then click OK to close the Data Link Properties dialog box.
Access connects the project to the SQL Server database.
Create a new SQL Server database
On the first page of the Microsoft SQL Server Database Wizard, enter the following information:
The SQL Server computer you want to use for this database
Your logon information
A name for the SQL Server database
Microsoft SQL Server Database Wizard
Note To skip the connection process at this time, click Cancel. Access creates the project, but it is not connected to a SQL Server database. Before you can do anything with the project, you will need to connect it to a SQL Server database, which you can do by using the steps in the next section.
Click Next to continue.
Access attempts to connect to the SQL server computer you specified. If Access cannot connect to the SQL server computer, it displays an error message describing the problem. The SQL server computer name or logon information might be incorrect, or you might not have the necessary permissions to create a database on the SQL Server computer that you specified. You might need to check with the SQL Server database administrator for the database you are creating, to make sure your settings are correct or that the computer is available.
After Access successfully connects to the SQL Server computer, the wizard displays the message: The wizard has all the information it needs to create your SQL Server database. Click Finish to continue.
Access creates the SQL Server database and connects it to the project.