I created an SQL query which give over 9000 records when run from the SQL server query analyser. But if I run the same query from Ms Access query grid, it is only returning 156 records. I have tweaked the Tools >. Options > Advanced tab to set the default max record to 10000 but this does not seems to have any effect on the number of records pooled from the server. Please help.