I have this terrible problem which I cannot get around. <BR><BR>I am connecting to an MS Access 97 database through ASP. I have a simple SQL query with two joins and three tables. When this query should return no rows at all, the ADO recordset contains an empty record with nulls and default values. What is going on here? If there are no records in the query results, why is there an empty record in the recordset?<BR><BR>Please help<BR><BR>Thanks<BR>Matthew