• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Developing an ADP Application > Creating an Access Project

Creating an Access Project

The process of creating an Access Project involves creating the ADP and designating the SQL Server database to which it is associated. To create an Access Project:

1.
Click the New button on the toolbar. The New Task Pane appears (see Figure 12.1).

Figure 12.1. The New dialog box allows you to create an ADP based on a new or existing SQL Server database.


2.
Two options allow you to build an ADP. The first allows you to create an ADP file using an existing SQL Server database. The second allows you to build an ADP file based on a new SQL Server database. If you click Project (Existing Data), Access creates an Access Project based on an existing SQL Server database. The File New Database dialog box appears. Enter the name and location of the ADP file, and click Create. The Data Link Properties dialog box appears (see Figure 12.2).

Figure 12.2. The Data Link Properties dialog box allows you to specify connection information about the SQL Server database that the ADP file is associated with.


3.
Enter the server name, the security information, and the name of the database that you want to connect to.

4.
Click the Advanced tab to enter advanced options or the All tab to view or modify any connection options.

5.
When you're finished specifying all options, click the Connection tab and click Test Connection to ensure that you have correctly specified all of the settings.

6.
Click OK to create the Access Project.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint