Design mode limits certain tables to the first 1000 records. This allows you to design and save your workbook without waiting for large requests to finish. See the table '_DESIGN_MODE' for details.