Opening .ADP in MS SQL Server

Hi, does anyone know how to open a .ADP (Access Project) database in MS SQL Server Perhaps it will then need to be converted to .mdf.

Thank you.



Answer this question

Opening .ADP in MS SQL Server

  • Ben Shemmeld

    If you have used access upsizing util, you will find the .mdf file in the program files\microsoft sql server\........\data\ folder. If lost just do a search on all .mdf files. For some reason the upsizing tool doesn't place the .mdf file in the same place as the .mdb. Hope this helps!

  • Kenneth Davidsen

    Excellent, I will search for an mdf file...
  • Paul60

    I located the .mdf file. However, I am having difficulty establishing this server connection in MS Visual Studio 2005. The tables are just not showing up in the final database view. Do you know what properties/settings I should be choosing when establishing the connection to my database I am running MS SQL Server 2000.

    Thank you.


  • Opening .ADP in MS SQL Server