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