Relationship of Jet4.0.8 thru VB to Access versions?

[Pete]

Hi - I normally talk to Jet 4.0.8 through ADODB in VB6, no problem.
Occasionally I construct SQL in Access 2003 but use it in VB6.
Recently I was sent an mdb file that works perfectly well with
Jet4.0/VB6 but when I bring it up in Access 2003 it says "This database
was created in an earlier version of Microsoft Office Access. To
convert to the current version ..." I am puzzled because I thought
that Jet4.0 created the mdb file and that Access is only a front end
that talks to Jet4.0 like I do with my VB6 front end. So in what way
does the "database" have an Access version attached to it that seems to
be ignored during my VB6 accesses? I have no problem, but I would sure
like to get a clearer understanding of what's going on. Help would be
appreciated!

- Pete

 

[david epsom dot com dot au]

Access is a Rapid Application Development system that
stores an Access Project in a Jet ('Access') database.

Access will offer to 'convert' any Jet database
that does not contain an Access Project in the
current (default) version.

Access is the only product that can create, read,
modify or convert an Access Project.

Jet ('Access') databases created by any other
means don't include an Access Project, and Access
will offer to 'convert' them if given the chance.

In particular, the Jet databases created by DAO
and ADOX methods do not include Access Projects,
but work perfectly well for all purposes.

(david)

 

[Pete]

Many thanks! Very enlightening.

- Pete