Home > Archive > MS Access data conversion > November 2005 > Version of a database









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Version of a database
Lorenz Ingold

2005-11-11, 7:24 am

I want to write a VB6 tool that (among other) can take a file specification
of an mdb-file and tell me whether it is in Access97-, Access2000- or
Access2002/2003-format. However, all I found out is that I could get the
Jet-Version of the file. I use the following code:
Set objDatabase = objDaoWorkspace. OpenDatabase(filespe
c, ...)
varVersion = objDatabase.Version
This gives 3.0 for an Access97-database and 4.0 for an Access2000-database
and all highers. So I even cannot distinguish between Access2000 and
2002/2003 formats. How can I find out programmatically the Access-Version of
a database?



Jeff Boyce

2005-11-11, 7:24 am

Lorenz

?Had any luck searching at Google.com?

Jeff Boyce
<Office/Access MVP>

"Lorenz Ingold" <l.ingold@comteach.ch> wrote in message
news:dl1qq5$nu$4@new
s.imp.ch...
> I want to write a VB6 tool that (among other) can take a file

specification
> of an mdb-file and tell me whether it is in Access97-, Access2000- or
> Access2002/2003-format. However, all I found out is that I could get the
> Jet-Version of the file. I use the following code:
> Set objDatabase = objDaoWorkspace. OpenDatabase(filespe
c, ...)
> varVersion = objDatabase.Version
> This gives 3.0 for an Access97-database and 4.0 for an Access2000-database
> and all highers. So I even cannot distinguish between Access2000 and
> 2002/2003 formats. How can I find out programmatically the Access-Version

of
> a database?
>
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com