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/