[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
        Dim mstrCnnJet As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
        mstrCnn = mstrCnnJet & lstrMDBFileSpec
        mstrTblName = lstrTblName
    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

John W. Colby

Contribute your unused CPU cycles to a good cause:

More information about the dba-VB mailing list