Can Access 2007 develop a 2003 app to run on access 2003 runtime

[David W. Fenton]

Quite correct and since I'm new here, I don't have any idea if
this was a planned "feature" or just an interesting quirk. My gut
tells me this was planned so developers could still use some of
the depracated features and create an MDE for distribution. I
might ask around out of curiousity.

There's nothing at all different about A2K7 that was not the case in
A2K3, A2K2 and A2K. All Access releases using the same Jet version
can open and run the MDBs of early versions, but an MDE is always
going to be specific to the VBA version it was compiled in.

 

[Marshall Barton]

Marshall Barton wrote


I don't think so. An A2K7 MDB is identical to an A2K3 MDB -- it can
run in either. But the MDE is *not* identical, even though the
source MDB is identical.

I think we're saying the same thing except for the label
that's applied. Some want to label the MDE by the format of
the MDB file, while I think it should be labeled by the
version of the VB library. I guess I am in the minority,
but it makes more sense to me :-\

We've never had any of that. It's taken years for MS to fix the
Access documentation back to its original state by adding back in
the DAO examples alongside the ADO/JRO.

True, but now that Jeff works for MS, I thought I'd stick it
to him about being a small cog in a big machine ;-)

 

['69 Camaro]

Hi, David.

An A2K MDB file can be used in all newer versions because the *Jet*
version is the same. An MDE can *not* be used because the VBA
version is not binary identical.

You make it sound like an Access 2000 MDE won't run in newer versions of
Access. It will if late binding is used for all non-default libraries,
which is a good practice anyway.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[David W. Fenton]

You make it sound like an Access 2000 MDE won't run in newer
versions of Access. It will if late binding is used for all
non-default libraries, which is a good practice anyway.

Well, I wasn't actually assuming that.