-
One other funny problem I have is that I have a SQL statemnt that deletes the contents of the table. If I step through the code in debug it deletes all the records, but if I run it from my app it does seem to delete. My cod eis as follows:
Dim rstcontrol As ADODB.Recordset
Set rstcontrol = cndata.Execute("Delete * from TempDatesTbl") 'cndata holds my connection string stuff
regards
Gerard
-
change your SQL statement to this:
Delete from TempDatesTbl
you also don't need to assign this to a recordset object, since an action query will not return any records...
-
Can you please show me some code how you would write the statment..without a recordset.
-
Dim cn As New ADODB.Connection
cn.Open "....."
cn.Execute "Delete From tblX"
cn.Close
set cn = Nothing
