Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
Contact Us
About Us
Member Login
Access 2010 FAQ

 

How do I create a new Access Data Project (ADP) in Access 2010? The program always wants to create a new ACCDB file format.

 

By default, Access 2010 creates new databases in the ACCDB file format. To create a new Access Data Project (ADP), first click the Blank Database button near the top center of the New tab on the Backstage view. Access displays the Blank Database task pane on the right side of the screen, as shown below.

 

Click the browse icon, shown above, to open the File New Database window. Next, click the arrow on the Save As Type drop down list and select the Microsoft Office Access Projects (*.adp) option, as shown below.

 

 

 

Browse to a folder location to save your new project, enter a name for the new project in the File Name text box, and then click the OK button to return to the New tab on the Backstage view. Finally, click the Create button in the Blank Database task pane to open your new Access Data Project.

 

Access then displays a message box asking whether you want to connect to an existing SQL Server database. If you click Yes, Access displays a Data Link Properties dialog box where you enter the connection information for your existing SQL Server database.

 

If you click No on the message box, Access creates the project for you and opens it. Because this is a new project, the Microsoft SQL Server Database Wizard opens and walks you through the process of creating a new Access Data Project.

 

Important Note: You won't be able to utilize some of the new features found in the ACCDB file format in your Access Data Project such as Multi-Value Field Lookups, Attachment, and Calculated data types.

 

You might also want to review this Help article concerning Access 2010 and ADP files:

http://office.microsoft.com/en-us/access-help/create-an-access-project-HA010341589.aspx?CTT=1#_Toc257281380

 

 

See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out

 

 

Back to FAQ main page