Access 2007 with Access 2010

[BradBrad]

Hi All,

If I develop a database in Access 2007 and then try to open it in Access 2010, will it work?

Thanks!

 

[JANR]

Shoulden't be a problem, but the otherway around is problematic.

2010 -> 2007

JR

 

[BradBrad]

Perfect! Thanks for your help.

 

[basstard80]

I though that latest version should support older one, but I'm still having some problems with piece of code written with Access 2007 and trying to run it on Access 2010... so if I spoke by personal experience I'd say "no it won't work" or at least "be careful".

 

[GinaWhipp]

@basstard80,

What code? Can you point me to the thread or post the code here?

 

[basstard80]

Gina, is the same problem you already tried to solve.

 

[GinaWhipp]

What same problem? If you are refering to the OP's issue then no it is not the same.

 

[HGMonaro]

regarding the 2010->2007 scenario, are there any work-arounds? I have a 2010 accdb I'd like to open in 2007 but it doesn't want to play nice!

Cheers, Nige

 

[GinaWhipp]

You would have to strip any 2010 features to be able to open in 2007...

 

[jonathanchye]

AFAIK If it's 2007->2010 only problems you might face are deprecated functions (ie the old calendar function in 07)

From 2010 -> 2007 s a bigger issue as 2010 introduces a lot of new features such as multivalue fields.

 

[HGMonaro]

You would have to strip any 2010 features to be able to open in 2007...

It was an A97 mdb opened in 2010 and converted to accdb, so no new features. When trying to open in 2007 it just says it's not able to open it (can't remember the exact msg and the guys 'puter that it's on isn't here ATM). 2010 dosen't seem to have any 'Save as 2007' functionality unless it hidden somewhere I can't find.

 

[HGMonaro]

probably best ignore me.. just found another thread on this issue and maybe the fact that I converted the A97 db into accdb rather than import the objects might be the issue... can't test it at the moment, will have to wait a few days

Cheers, Nige

 

[Banana]

From 2010 -> 2007 s a bigger issue as 2010 introduces a lot of new features such as multivalue fields.

Actually MVF were introduced in 2007 so that's not an issue. But your point in general still stands - one has to watch out for new features such as web browser control & navigation control, shared gallery and then few more.


Also note that it's not also always a simple matter of "not using any 2010 features" - there are several actions that may cause 2010-only features get added, a good example being the new MSysResources table. FMS has an article about this particular scenario.

I'm of opinion that you are far better off picking one or other. Remember both offer free runtime that everyone can download and use so you only need to pick one to develop with, and give your users the matching version runtime + your application + a handy shortcut and you've saved yourself a big headaches with handling differences between versions.