If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
10000 row limit
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? |
#3
|
|||
|
|||
10000 row limit
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? |
#4
|
|||
|
|||
10000 row limit
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? |
Thread Tools | |
Display Modes | |
|
|