Solved

Are Outlook 2010 and access 2000/3 compatible?

Posted on 2013-06-13
3
343 Views
Last Modified: 2013-06-18
Hi all, We have 2 access applications one is a MDB linked to sql server back end and the other is an ADP project, both are written in Access 2000 and uses also with 2003 without problems.
Now due to certain technical issues, we are considering upgrade them to Access 2010, are you aware of serious issues that may arise from such a move?
If the answer is yes, is there a place where we can get a list of problems to expect?
Also in case there is a major work involved, how about if we only upgrade the outlook to 2010 (which is the one causing trouble), and leave the rest of the office in 2000 or 2003, would they be compatible?
In general about all questions above, since we have in office both windows versions, XP Pro and Win7 (some already 64bit), is there one answer for all?
0
Comment
Question by:bfuchs
3 Comments
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 247 total points
ID: 39246117
It is generally not a good idea to mix Office versions, because of shared objects and references.  ADPs are on their way out in any case, so you may have to change that part of your app.  They are sort of supported in 2010, and not supported at all in 2013.

For Outlook code, I have had to make some minor changes when upgrading from 2003 to 2007 or 2010, but nothing major.
0
 
LVL 3

Author Comment

by:bfuchs
ID: 39246207
hi thanks for replying, some questions regarding the above,
1-What are the alternatives of ADP? (Besides of switching platforms completely..)
2-when you say sort of supported/ not supported, do you mean they will not work or that microsoft is not providing support for it?
3-In case you meant it does not work, what for example will not work?
4-we dont have code in Outlook, all is Access VBA, is the same true in this case.
5-Just curious, why did they stopped supporting ADP?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 248 total points
ID: 39247410
<<1-What are the alternatives of ADP? (Besides of switching platforms completely..)>>

 None really.   You end up working with SQL Server via ODBC and linked tables.

<<2-when you say sort of supported/ not supported, do you mean they will not work or that microsoft is not providing support for it?>>

 Will work in 2010 but no new features or improvements.  Will not work at all in 2013.

<<4-we dont have code in Outlook, all is Access VBA, is the same true in this case.>>

  Going from older to newer is never a problem and I don't think you'd have a problem using Outlook to simply send e-mail.  Using automation with Excel or Word would not be a problem either.

   Where you'd have a problem though is with things built into Office that you might use, such as charts/graphs, conversion tools, etc.

  My suggestion would be to get a copy of A2010, setup a test environment and test like crazy.  What your doing is not typically done.  Almost everyone keeps an older version of Access and works with a newer version of Office.  Not the other way around.

<<5-Just curious, why did they stopped supporting ADP? >>

 Stated reason was that it would have required to much work to make it work with Azure.

 Real reason I believe is they want everyone moving towards web apps and using Office 365.  Client database development with Access seems to be on it's way out.

Jim.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now