Hi,
I am trying to write some records into an access database. Following is the code:
Dim MyConn As ADODB.Connection
Dim WSRecSet As ADODB.Recordset
Dim OBRecSet As ADODB.Recordset
Dim ConfigItemRecSet As ADODB.Recordset
'Dim Ocmd As ADODB.Command
Dim strConn As String
Dim strSQL As String
strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=build_monitor.mdb;DefaultDir=C:\Docum ents and Settings\test\My Documents\test_build;UID=Admin;PWD=;"
Set MyConn = New ADODB.Connection
MyConn.ConnectionString = strConn
'Ocmd.ActiveConnection = MyConn.ConnectionString
MyConn.Open
The last line gives a runtime 13 error. I don't know what the problem is.
In my program I have set a reference to MS ActiveX Data Objects 2.8 library.
Thanks in advance,
mrk68