Cannot Querie More Reocrds from SQL.

  • Thread starter Thread starter jahangir khan
  • Start date Start date
J

jahangir khan

Hi Everyone.

I have a table in SQL. it contains employee details. Eg. name . id . sex etc.
... the primary key is the ID no.
ok now there are around 18000 records in this table.

i have made a form in Access. the user enters the ID number and the details
appear.. Every thing is fine..
but it does not qurie more then 4000 records.

if i enter any record that is after the 4000 it goes back to the start of
the table.

i have also created forward and back button on the form so you can see
records 1 by 1. well that works fine. but the search seems to only go and
featch records till 4000 ???
ANY 1 plsss HELP....
 
Hi,

Check under Tools | Options... [Advanced] Client-server setting, the
"Default max records" is maybe set to 4000.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top