Maximum recordsource size

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."
 
F

fredg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable entries in customer menu bar 2
Showing cards on buttons 1
Issuing DOS commands from VBA 6
Selecting all entries in a list-box 1
Reseting/selecting value in combo 2
Getting to a child from a parent 1
Accessing Excel from Access 3
Getting and displaying a list of files from the internet 1

Top