[AccessD] Cannot open second Recordset?!

Hi Sander

Maybe End is a reserved word?
Try leaving out one field name, then another etc. until the query
doesn't fail.

/gustav


> when I change the SQL:

> strSQL = "SELECT InterfaceID, FieldID, FieldName, Start, End, 
> Mandatory " & _
>             "FROM tblInterfaceLayout " & _
>             "WHERE InterfaceID = " & InterFaceID

> strSQL = "SELECT * FROM tblInterfaceLayout WHERE InterfaceID = " & InterFaceID

> it does work?! How is this possible? BTW i did NOT misspel the fieldnames because when I use the debug window to display strSQL I can run the query!!