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
Solved

Open Access 2003 .ade file using Access 2010 runtime

Posted on 2013-01-29
5
1,727 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
  • 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 84

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

829 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