Your recordset would look to see if there is already a record that has a start time that is after the requested start time that is between the requested start and end time, or an end time that is between the requested start time and end time. Then you can check the TotalRows of the recordset to see if there is a conflict based on if that recordset has a result or not.