Are there problems working with Access 2003 and Access2007?

[Kim]

Hi,

I've been doing some developing in Access 2007 and some in Access
2003.

I seem to have the issue that, when I design a form in 2007 and attach
a button to a query or other form, it won't work in 2003 and gives me
an error.

Is there a known incompatability issue between the two?

If not, what's the resolution?

Thanks all.

Kim

 

[David-W-Fenton]

m:

I seem to have the issue that, when I design a form in 2007 and
attach a button to a query or other form, it won't work in 2003
and gives me an error.

Is there a known incompatability issue between the two?

If not, what's the resolution?

Theoretically, it should work.

If I were forced to do a change in A2007 that had to run in A2003,
before distributing it for A2003 users, I'd decompile it in A2003
and do a compact/recompile cycle, to make sure that the VBA
project's compiled p-code didn't have anything remaining in it that
was created within A2007 (and could potentially be problematic in
A2003).

But the real solution is to never make changes in A2007 for an app
that has to be used by A2003 users -- you should always do
development in the lowest version available to your users.

 

[Kim]

Theoretically, it should work.

If I were forced to do a change in A2007 that had to run in A2003,
before distributing it for A2003 users, I'd decompile it in A2003
and do a compact/recompile cycle, to make sure that the VBA
project's compiled p-code didn't have anything remaining in it that
was created within A2007 (and could potentially be problematic in
A2003).

But the real solution is to never make changes in A2007 for an app
that has to be used by A2003 users -- you should always do
development in the lowest version available to your users.

Thanks David. I actually did a repair on Office 2010 and it fixed the
problem. I also find that if I manual link my buttons using the docmd
command, rather than linking through the menus, it works a treat.

Thanks again.

Kim