Convert 2007 adp to access 365 accdb

[Mack13]

I have on old access adp project (2007 I believe). I need to convert to Office 365 access accdb format. The old project had linked tables to a sql db. I don't need those linked tables as I will be importing them from the sql db into access tables. How do I convert the project? Or how can I copy forms, reports...etc to the new accdb?

[mike60smart]

Hi
First Import all tables into a New Database.
Then Import all the Objects from the Old Access Project into the same New database

[Mack13]

I had already imported the tables. I'm having trouble importing other objects. If I import a query, it imports as a table with the query results. Copy from old db and paste to new db doesn't work on forms, reports, and queries.

[mike60smart]

Hi
You should Import all objects at the same time.

[madpiet]

I had already imported the tables. I'm having trouble importing other objects. If I import a query, it imports as a table with the query results. Copy from old db and paste to new db doesn't work on forms, reports, and queries.

The problem you're likely going to have is with the Stored Procedures and Views in SQL Server. There are some features of stored procedures etc that are not directly comparable to Access queries, so you may need someone who can interpret what the SQL Server views and stored procedures do/return and rewrite those as Access queries. Might not be that bad since ADPs are old and SQL Server at that time wasn't nearly as complicated as it is now. but it still won't be super easy, I don't think.

Maybe that's why Access is importing some things as tables. There's not always an easy way to rewrite T-SQL as Access SQL.

[Mack13]

I should be able to copy the sql statement from the queries and create new ones in the new db. But I'd love to be able to get the forms and reports from the old db into the new db.

[mike60smart]

Hi

When you go through the Import process your 1st step is to select the Query Tab and then the option to Select All

Next click on the Forms Tab and then the option to Select All

Do this for Reports, Macros and Modules

Then lastly click on the OK Button

[CJ_London]

Copy from old db and paste to new db doesn't work

as Mike is suggesting use the import routine - see the external data tab on the ribbon

[Micron]

And the reason for putting all the tables in the same db as the reports/forms/queries is?? So that you can split it later?

[mike60smart]

Hi Micron
Yes

[Minty]

It's not a trivial task moving an ADP into access or even converting the front end to use a "normal" SQL Server backend, as everything is achieved through specific stored procedures and views.

We moved a large ADP application for a government agency to a conventional access front end SQL back end and it has taken well over a year of work on and off.

[Mack13]

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. When I try to import and connect to my sql database, the only tab I get on the import is tables which also has the queries results.

[Mack13]

We are doing away with SQL. Why wouldn't I put it all in one access db? It's a 1-person db operation and not a lot of data.

[Mack13]

BINGO! Plus, we are getting rid of sql. This is a small application as for the amount of data we keep.

[CJ_London]

Why wouldn't I put it all in one access db? It's a 1-person db operation and not a lot of data.

Google and find out all the problems you could get. Ok for a noddy/temp db, but for one that forms part of your business process, not a good idea. If data changes regularly, do plenty of backups