Show All

Hide All

Some of the content in this topic may not be applicable to some languages.

You can create a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.) and connect it to a Microsoft SQL Server (Microsoft SQL Server database: A database in Microsoft SQL Server, it consists of tables, views, indexes, stored procedures, functions, and triggers.) database.

1. On the File menu, click New.
2. Do one of the following:

   Create a Microsoft Access project and connect it to an existing Microsoft SQL Server database

   1. In the New File task pane, under New, click Project (Existing Data).

   2. In the File New Database dialog box, click a location in the Save in box, and type a name in the File name box; make sure that Microsoft Access Projects appears in the Save as type box, and then click Create.

   3. On the Connection tab in the Data Link Properties dialog box, enter a server name and the information necessary to log on to the server, and then select the database on the server. For additional information, click Help in the Data Link Properties dialog box.

   Create a SQL Server database and connect an Access project to it

   1. In the New File task pane, under New, click Project (New Data).

   2. In the File New Database dialog box, click a location in the Save in box, and type a name in the File name box; make sure that Microsoft Access Projects appears in the Save as type box, and then click Create.
   3. In the Microsoft SQL Server Database Wizard, type the name of the server you would like to use, the logon ID and password of an account with CREATE DATABASE privileges on the server, and the name of the new SQL Server database.

   4. Click Next.

   5. If you are creating a Microsoft SQL Server 6.5 database, enter the database device and size, the transaction log device and size, the database size, and the log size. You don't need to specify devices and sizes for Microsoft SQL Server 7.0 or later.
   6. Click Finish.

   Create an Access project that is not connected to a Microsoft SQL Server database

   1. In the New File task pane, under New, click Project (Existing Data).

   2. In the File New Database dialog box, click a location in the Save in box, and then type a name in the File name box; make sure that Microsoft Access Projects appears in the Save as type box, and then click Create.
   3. In the Data Link Properties dialog box, click Cancel.