10000 row limit

[Computermike]

I recently created a Access project with my tables in SQL Server 2000. I
created the project and specified my SQL server as the data source. It
created the project and all my tables and sprocs showed up, but when I run a
sproc that I know returns 40,000 records only the first 10,000 show in the
query results data grid. Can I fix this? Are my queries limited to 10,000?

 

[Sylvain Lafontaine]

Tools | Options | Advanced | Default Max Records: set this value to
something greater than 10000. I think that 0 is infinite but I'm not sure.

The newsgroup for ADP is m.p.access.adp.sqlserver.

 

[Pat Hartman \(MVP\)]

Why in the world would you ever return a recordset containing 10,000 rows?
No one can use that amount of data. Filter the recordset on the server to
take advantage of the client/server environment and only return a limited
set of data to the Access form.

 

[Computermike]

You are right about the large data set. I was just wondering why the data
was limited and if it would affect my proccessing sprocs.

Good point