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/