Error 3001 During DEBUG Only?Feb 24, 2011
When I debug this project, I receive the following error:"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." It happens on the recordset open call.
rsData.Open "SELECT * FROM " & TempTableName & " WHERE 1 = 2", SQLConn, adOpenDynamic, adLockBatchOptimistic
The odd thing is that it only happens during debug. When I compile the .dll and use it, no error.I need to debug to filter review some data that is rejected in a later procedure.
Private Function CopyData _
(ByRef SQLConn As ADODB.Connection, _
ByRef SourceData As ADODB.Recordset, _