Maximum recordsource size

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

Anyone know what the maximum size for a recordsource is in Access 2000?
I have an SQL statement of length 2208 and it complains it is too large (I
know that it is big - can't be helped).


--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Anyone know what the maximum size for a recordsource is in Access 2000?
I have an SQL statement of length 2208 and it complains it is too large (I
know that it is big - can't be helped).
Click to expand...

Access Help files.
Specification + Access Specifications

Number of characters in an SQL statement that serves as the
Recordsource or Rowsource property of a form, report, or control (both
..mdb and .adp) 32,750
 
Back
Top