asked on

Access error "Access Data Projects are no long supported in this version of Access"

Hello. Can someone tell me the best steps to fix this? I have an old access data project that no longer works on newer versions of Access. Now whenever I click on the file I get this error, "Access Data Projects are no longer supported in this version of Access.". I have already exported the actual database tables to my sql server which is running sql server 2008 R2. But the user interface is still at .adp file which is now linked to my sql server. It would be great if I could just turn it all into web forms or something but I don't know how I can export all the queries, forms and reports that are in the project. I am able to open the .adp file on a virtual machine where I am running an older version of Access in a Windows 7 environment.

thanks

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Nick67

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cdlciddit

ASKER

Hello @Jim Dettman and @Nick67. Thanks for the information. I have already put the tables in SQL and that Access Data Project just links to them. I would prefer to get rid of Access all together. I don't see any advantage to using it since I have SQL Server. I was only dealing with it because it was something that someone made before me and I was just trying to support it. So what is the best way to go about recreating or exporting the forms, reports and queries?

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Nick67

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cdlciddit

ASKER

Thanks guys. I guess I will have to recreate it using Visual Studio and c#.net since that is what I'm starting to learn. I appreciate the explanations.

Access error &quot;Access Data Projects are no long supported in this version of Access&quot;

Access error "Access Data Projects are no long supported in this version of Access"