Convert 2007 adp to access 365 accdb

[Welshgasman]

Doesn't hurt to split, even for a noddy DB.


I have my Diabetes DB split for that very reason. Only me and a little data, but the data stays apart from forms and code.

[madpiet]

The fun part is going to be rewriting all the stored procedures and views. Especially with the wonky way Access uses VBA where T-SQL lets you define variables and do looping etc natively. That's gonna be the hard part.

[Mack13]

So, you keep the tables in a separate access db and all other objects in a separate access db?

[Mack13]

So, you keep the tables in a separate access db and all other objects in a separate access db?

[Mack13]

I'm trying to get forms and reports over to the new db without having to recreate them. Then I'll worry about stored procedures and such.

[CJ_London]

If I try to import from the old access database, it tells me that the version of the db I'm trying to connect to is too old.

Later versions will open any version back to 2000. ADP ceased with 2003 although later versions would support it to preserve backwards compatibility. So I suspect your 2007 guess in post #1 is wrong and I suspect you have a .mdb, not .accdb and it was created in a version earlier than 2000 and never updated.

If that is the case, you will need to update it to 2000 or later before you can then import to 365

[Welshgasman]

I have 2007 which will convert earlier (at least 2003 mdb) to accdb.

[mike60smart]

I have Office 2003 if you want me to convert from mdb

[Mack13]

My db is an adp.

[CJ_London]

but the forms/reports/modules are still access and that's the bit you want.

Have you tried converting the .adp to a .mdb or .accdb? See if this link helps

https://www.accessrepairnrecovery.co...-or-mdb-format

in particular:

Steps To Convert ADP File To MDB :

• Firstly you need to Open your Microsoft Access.
• After then tap to the “File” option menu bar and click to “Open,” option.
• Now hit the ADP file that you need to convert to MDB format.
• Then click to the “File,” option and then click “Share”. After then hit the “Save Database As” option.

[Mack13]

Thanks, I'll take a look at that.

[mike60smart]

Hi Everyone.

The Op has sent me a copy of the database and I have Imported all Objects into a New Database for him

[Mack13]

Thank you all for your help and suggestions.