Re: Division by Zero Error - Help Urgent

swami@xxxxxxxxxxxxxxxxxxxxxx wrote:

Hi All,
I'm getting a weird problem..
This happens only on ONE desktop... Other PC's the same works fine
without any problem..

strSQL=  "select max(last_edit_date) from TABLE1"
Dim rsrec As New ADODB.Recordset
 rsrec.Open strSQL, conn, adOpenStatic, adLockOptimistic, adCmdText

<snip>

When I run into problems like this I start changing everything in sight, one variable at a time, using trial and error to see if I can learn more about the error.

Did you try different strSQL, e.g. maybe take the max() out, read everything from the table, stuff like that?

Did you try
Dim rsrec As ADODB.Recordset
Set rsrec = New ADODB.Recordset

Mike
.

Relevant Pages