2007, 2010, and 2013 Access Compatibility Issues

[data808]

I've looked online at the features that were being added and thrown out in these versions on the microsoft site but did not really find anything that seemed related to me. I was just wondering if anyone had any tips or bad experiences with this. I work in an office that has all these versions of Office running at the moment. The database I created is from a 2007 version of Office. My concern is that how well is it going to run on the other versions (2010 and 2013)? I am a little worried that I may run into some big problems. Is there anything I need to look out for?

[s_solt]

I've looked online at the features that were being added and thrown out in these versions on the microsoft site but did not really find anything that seemed related to me. I was just wondering if anyone had any tips or bad experiences with this. I work in an office that has all these versions of Office running at the moment. The database I created is from a 2007 version of Office. My concern is that how well is it going to run on the other versions (2010 and 2013)? I am a little worried that I may run into some big problems. Is there anything I need to look out for?

The most significant change for Access developers is that Access 2013 drops support for .adp or .ade Access Projects connected to SQL Server. It appears, however, that Access 2013 will run alongside 2010 so I am looking at continuing to use Access 2010 runtime to support my existing Access Project applications.


I have checked online today and Access 2010 is (supposedly) still in stock on http://www.ecostsoftware.com/microso...ess-2010_p5001

NB I am aware of problems with Office 2007 and Access 2010 which cause fatal execution errors when Access attempts to control another program (eg AutoCAD) via OLE.

Stephen Solt

[data808]

Are .adp and .ade file extensions? Also what is AutoCad OLE? Sorry, kind of new to Access.

[June7]

.adp and .ade are Access file extensions from version 2003 and earlier

OLE: http://en.wikipedia.org/wiki/Object_..._and_Embedding

Some users have been disappointed by 2013 dropping support for Collect Data (partial - can't build new), Pivot Tables/Charts, dbf files.