10000 row limit

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?

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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Computermike" wrote in message
...
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?

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" wrote in message
...
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?

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

"Pat Hartman (MVP)" wrote:

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" wrote in message
...
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?