Question How to convert an ADP to ACCDB

[OwenOC]

Hi

I have a (Access Data Project) ADP project which was created in Access 2003.

I need to convert it into an ACCDB file with Access 2007. Does anyboyd know how to do this besides exporting each and every table, query,report etc one by one ?

I was hoping there was something where I could import or export the whole thing in one go.

Any help appreciated

OOC

 

[OwenOC]

I guess by the silence this post has received then it must be impossible:banghead: ?

 

[Trevor G]

I believe you need to convert your ADP SQL code into ADO within Access. How this is done I am not totally sure as I am not aware of the ADP SQL Server side.

I don't know if this link will help but there are suggestion of third party software to help

http://www.pcreview.co.uk/threads/converting-application-from-adp-to-accdb.3829876/