The code worked fine with Sybase, now database has been moved to MS SQL, and it runs into error. It seems that it has issue to run INSERT INTO or UPDATE code.
What does error mean? object in the screenshot is table_name.
Set CnDev = CreateObject("ADODB.Connection") CnDev.Open ConnectionString TestQuery = "INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)” Set TestRs = CreateObject("ADODB.Recordset") TestRs.Open TestQuery, CnDev Set TestRs = Nothing