[dba-VB] .net correct version of jet

John W. Colby jwcolby at colbyconsulting.com
Sun Jul 24 07:14:49 CDT 2005


I am using the following code to set up a connection.

    Public Sub New(ByVal lstrMDBFileSpec As String, ByVal lstrTblName As
String)
        Dim mstrCnnJet As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
        mstrCnn = mstrCnnJet & lstrMDBFileSpec
        mstrTblName = lstrTblName
        LoadSysVars(mstrCnn)
    End Sub

The code passes in a filespec for an MDB container that a table resides in
and the table name.  Inside new() the mstrcnn is built up by appending
mstrCnnJet and lstrMDBFileSpec.  This works but it seems that I am getting
awfully specific in mstrCnnJet.  Is there a way to determine what version of
Microsoft.Jet.OLEDB is available on the machine that the code is running on?
Or is this a non-issue as there is only (and will only ever be) one version
(4.0)?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/





More information about the dba-VB mailing list