ORDER BY error:

[djh]

Weird... I'm totally baffled.

If I put in an ORDER BY clause in my SQL statement, I get an error:

"Method 'Open' of object ' Recordset failed"

If I don't put the ORDER BY clause, it works fine.

Here's what I'm using:

Set rst=New ADODB.recordset
strSQL="SELECT temp.* FROM temp ORDER BY temp.size;"

With rst
.activeConnection=currentProject.Connection
.CursorType=adOpenKeyset
.LockType=adLockOptimistic
.Open strSQL
End With

Same thing with [temp].[size]....

Help??

 

[djh]

Never mind, i put the field names in brackets and the clause in paranthesis, and it worked...