.adp conversion to .accdb

%3CLINGO-SUB%20id%3D%22lingo-sub-2622358%22%20slang%3D%22en-US%22%3E.adp%20conversion%20to%20.accdb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2622358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20an%20old%20.adp%20MS%20Access%20and%20need%20to%20convert%20it%20to%20.accdb.%26nbsp%3B%20It%20can%20be%20opened%20in%20MS%20Access%202007%26nbsp%3B%20version%20but%20there%20was%20no%20save-as%20or%20publishing%20option%20for%20.mdb.%20I%20have%20also%20tried%20creating%20a%20new%20database%20.accdb%20file%20in%20MS%20Access%20through%20Microsoft%20365%2C%20then%20utilized%20external%20data%20by%20import%20or%20link%20the%20elements%20from%20this%20.adp%20file.%20But%20it%20didn't%20work%20either.%20MS%20Access%20pops%20up%20this%20error%20for%20everything%20I%20tried.%20How%20can%20I%20convert%20the%20.adp%20file%20to%20a%20.mbd%20or%20.accdb%3F%20Thank%20you.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22unnamed.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301318iD87328E8D8223A5C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22unnamed.png%22%20alt%3D%22unnamed.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2622358%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eaccdb%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eadp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Econvert%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2622380%22%20slang%3D%22en-US%22%3ERe%3A%20.adp%20conversion%20to%20.accdb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2622380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122581%22%20target%3D%22_blank%22%3E%40-resolution%3C%2FA%3E%26nbsp%3BI%20think%20%22conversion%22%20is%20off%20the%20table%20in%20any%20event.%20I%20don't%20believe%20it%20ever%20was%20something%20you%20could%20do.%20I%20believe%20you%20CAN%20retrieve%20any%20data%2C%20though%2C%20because%20would%20be%20stored%20in%20a%20SQL%20Server%20database%20to%20which%20you%20could%20also%20link%20a%20new%20accdb.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2623079%22%20slang%3D%22en-US%22%3ERe%3A%20.adp%20conversion%20to%20.accdb%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2623079%22%20slang%3D%22en-US%22%3EUntested%20but%20could%20you%20do%20the%20following%3F%3CBR%20%2F%3ECreate%20a%20new%20database%20in%20A2007%20and%20link%20to%20the%20ADP.%3CBR%20%2F%3ERight%20click%20on%20the%20linked%20tables%20and%20convert%20to%20local%20tables.%3CBR%20%2F%3EIf%20that%20works%2C%20you%20can%20can%20now%20use%20this%20database%20in%20A365%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an old .adp MS Access and need to convert it to .accdb.  It can be opened in MS Access 2007  version but there was no save-as or publishing option for .mdb. I have also tried creating a new database .accdb file in MS Access through Microsoft 365, then utilized external data by import or link the elements from this .adp file. But it didn't work either. MS Access pops up this error for everything I tried. How can I convert the .adp file to a .mbd or .accdb? Thank you.

 

unnamed.png

3 Replies

@-resolution I think "conversion" is off the table in any event. I don't believe it ever was something you could do. I believe you CAN retrieve any data, though, because would be stored in a SQL Server database to which you could also link a new accdb.

 

Untested but could you do the following?
Create a new database in A2007 and link to the ADP.
Right click on the linked tables and convert to local tables.
If that works, you can can now use this database in A365
Alternatively, just create a new A365 database and link to the SQL Server tables used in your old ADP.