|
 |
access thread: Getting the version of jet
Message #1 by "Phillip Johnson" <phillip.johnson@e...> on Wed, 23 Jan 2002 15:34:58
|
|
Hello, I need to know how I can get the version of Jet that is used by the
version of access that is running. I need to do this through code as I
dont know which version of access will be running.
Kind regards,
Phillip
Message #2 by "Randy Cornish" <rlcornish@c...> on Thu, 24 Jan 2002 02:03:36
|
|
Try this code:
Public Function JetVersion(MDBFileName As String) As String
Dim MyDB As DAO.Database '* ref to MS DAO 3.x
Set MyDB = DAO.OpenDatabase(MDBFileName)
JetVersion = MyDB.Version
Set MyDB = Nothing
End Function
R
> Hello, I need to know how I can get the version of Jet that is used by
the
> version of access that is running. I need to do this through code as I
> dont know which version of access will be running.
>
Message #3 by "Phillip Johnson" <phillip.johnson@e...> on Fri, 25 Jan 2002 12:50:13
|
|
Thanks Randy,
I have already coded it differently now and that works, but I will
certainly try that the next time I come up against the problem.
Regards, Phillip
> Try this code:
>
> Public Function JetVersion(MDBFileName As String) As String
> Dim MyDB As DAO.Database '* ref to MS DAO 3.x
>
> Set MyDB = DAO.OpenDatabase(MDBFileName)
> JetVersion = MyDB.Version
> Set MyDB = Nothing
>
> End Function
>
> R
>
> > Hello, I need to know how I can get the version of Jet that is used by
> the
> > version of access that is running. I need to do this through code as
I
> > dont know which version of access will be running.
> >
|
|
|
View Cart
