Only 50000 records returned from query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lauren Quantrell
    #1

    Only 50000 records returned from query

    I'm using a sproc to query a SQL Server table with about 300,000 rows,
    but when I query the table using a select query, it returns only
    exactly 50,000 rows. The front end is an Access 2000 application. I
    suspect that's the culprit even though max records is set to zero?
    I must be missing something.
    Thanks,
    lq
    Tags: None
    • Rich P
      #2
      Re: Only 50000 records returned from query

      Greetings,

      Do you have access to the code for your SP? Maybe your table in
      question really has only 50,000 rows but the sp is joining a bigger
      table to this one with a left join or maybe the sp is doing a Union All
      to some other tables?

      If you have access to query analyzer do a

      select count(*) from tbl_In_question

      Rich

      *** Sent via Developersdex http://www.developersdex.com ***

        Comment

        • Harry Skelton
          #3
          Re: Only 50000 records returned from query

          Lauren Quantrell wrote:
          ...The front end is an Access 2000 application. I
          suspect that's the culprit even though max records is set to zero?
          I must be missing something.
          Access does limit the records. You can try to alter the query limits
          from inside access. I had the same problem with Informix 4GL years ago.
          Its all about what you use to access the records.

          If you VBA, you may want to use ADO and open the SQL server directly
          rather than let Access to natively query via a form, et al.

            Comment

            • Lauren Quantrell
              #4
              Re: Only 50000 records returned from query

              Harry,
              I can create the connection directly in VBA, I'll try that. Currently
              the sproc is just a recordsource on a form.
              lq


              On Apr 17, 7:22 pm, Harry Skelton <skelton.ha...@ gmail.comwrote:
              Lauren Quantrell wrote:
              ...The front end is an Access 2000 application. I
              suspect that's the culprit even though max records is set to zero?
              I must be missing something.
              >
              Access does limit the records.  You can try to alter the query limits
              from inside access.  I had the same problem with Informix 4GL years ago.
                Its all about what you use to access the records.
              >
              If you VBA, you may want to use ADO and open the SQL server directly
              rather than let Access to natively query via a form, et al.

                Comment

                • Lauren Quantrell
                  #5
                  Re: Only 50000 records returned from query

                  I just realized there's a form level property - max records. It was
                  set to 50000. Mystery solved. Thanks.
                  lq

                  On Apr 17, 7:22 pm, Harry Skelton <skelton.ha...@ gmail.comwrote:
                  Lauren Quantrell wrote:
                  ...The front end is an Access 2000 application. I
                  suspect that's the culprit even though max records is set to zero?
                  I must be missing something.
                  >
                  Access does limit the records.  You can try to alter the query limits
                  from inside access.  I had the same problem with Informix 4GL years ago.
                    Its all about what you use to access the records.
                  >
                  If you VBA, you may want to use ADO and open the SQL server directly
                  rather than let Access to natively query via a form, et al.

                    Comment

                    Previous template Next
                    Working...