SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server with MS Access .adp Project file

MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in the same way as MS Access mdb files. The MS Access files that can connect to the SQL Server has the extension .adp (Access Data Project - file) and after the successful connection you can manipulate with data using Forms, Reports, Macros from Access side and Queries, as well as Store Procedures and UDFs.

The possibility for connection from MS Access adp files are since early Access version ( from 2000, XP, 2003, 2007), and here I will cover the Access 2010 the newest version of MS Office packet.

Create .adp file from MS Access:

Start the MS Access from Start menu > All Programs > Microsoft Office > MS Access. In the right of the Access windows, you have possibility to open the folder place where do you want to save the Access file, so you choose the folder name from dialog box but you should save it as type .adp file like in the fig below


After you created the adp file and saving it, in to the folder, now you can set up the connection to your SQL Server, opening that file and click to the File Red Menu:

SQLServerConn Settings

After you click the Connection, you will see the dialog box that uses to put SQL Server name and other details for the successful connection to the SQL Server Database.


According to the dialog box for the connection, you should put SQL Server name, then to choose the one of the connection way (Windows Authentication or Windows username (no need password it will recognize from your windows user-name) or SQL Server Authentication thar requires the SQL User-name and Password, in this case you should choose to Allow saving Password, when you reopen that file. Finally, you should select the database that is located to your SQL Server then click Test (testing connection) and OK.

On the left side of the MS Access adp project file you will see the core objects that are in your SQL Server database such as tables, views, store procedures, functions etc. Now you will be able to use these objects that are in you SQL Server Database and publishing the data from your SQL Server using forms, also you will be able to create reports...etc.

All the MS Access users can manage and work with SQL Server databases and can use much more like Store Procedures...

Have a nice SQLing with MS Access...

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...


Posted by Anonymous on 11 May 2010

Pingback from  Twitter Trackbacks for                 SQL Server Central, SQL Server with MS Access .adp Project file - Dukagjin Maloku - Dugi'SQL         [sqlservercentral.com]        on Topsy.com

Posted by johnmarsing on 16 May 2010

I thought ADP's were being deprecated.

Posted by niall.baird on 16 May 2010

@johnmarsing: we can only hope!!!!

Posted by gstaibano on 17 May 2010

ADP's are a great matter. Access is one of the best RAD ever done, and it is a sin the MS in a next future (I hope most far possible...) will discontinue it...  


Gianni Staibano



Posted by southlightvn on 19 August 2014

Hi Maloku,

Thanks for your post. I an newbie here at this site,hence just see your post in 2010...okay,old for here,but new for me.

According to your instruction I did accordingly but could not save the file as ADP,because it is not visible this to save. So I create a Database and save as...but by save as type there is only Microsoft Access Database to see and to save. Can you pls. provide further help for this?

Actually my concern is: I want to create a database with access. After that,when it is finished,I want to save that created database on the server as ACCDE format and the users can have the access to that server from out side to work on that created database at any time. But I try to find many ways which provided by MS but it was not successful. Can you and other help me with this? Thanks for your kind support in advance.



Leave a Comment

Please register or log in to leave a comment.