Solved

Open Access 2003 .ade file using Access 2010 runtime

Posted on 2013-01-29
5
1,790 Views
Last Modified: 2013-01-30
Can my end users that are using the Access 2010 runtime, others are using the Access 2007 runtime and others have the actual Access 2010 program work with an .ade file whose .adp file was compiled and created in Access 2010?

Will this cause any corruptions to the .ade file?
0
Comment
Question by:printmedia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 20

Expert Comment

by:GrahamMandeno
ID: 38833664
I cannot give you a definitive answer, but I believe your .ade will open and run fine in both the runtime and full versions of Access 2010, but I expect you will have trouble using it with Access 2007 runtime.

I suggest you try it.  If there is any problem then at worst it will damage the .ade (for which you will have a backup copy!!!) and it will not hurt the SQL Server data.

-- Graham [Access MVP 1996-2013]
0
 

Author Comment

by:printmedia
ID: 38833691
How about if the .adp and .ade was created in Access 2003?
0
 
LVL 20

Accepted Solution

by:
GrahamMandeno earned 250 total points
ID: 38834021
I haven't tried it, but in my opinion it should work in both 2007 and 2010.

Once again, you can confirm this by trial.
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 38834469
I have had mixed results with these sorts of setups  - sometimes the .ade/.mde will open and run fine in all versions, while at other times the .ade/.mde will open on some but not others.

As Graham mentions, you should test this out thoroughly. the only way to do this is to setup "testbed" environments - that is, virtual or physical machines that emulate your user's environments  as closely as possible - and test the application thoroughly in all those environments.

Note too that ADPs are no longer supported in Access. MSFT officially dropped them in the most recent version:

http://msdn.microsoft.com/en-us/library/office/jj618413.aspx

In fact, since 2007 MSFT has made it somewhat difficult to even create a new .adp file (the writing has been on the wall for some time, in other words).
0
 

Author Comment

by:printmedia
ID: 38834872
Ok thanks everyone. It looks like it might be possible as long as the runtime version is of a newer version than the adp version, but it won't work if it's reversed (adp was created in Access 2010 but the runtime is version 2003).
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question