Max RecordSource length

  • Thread starter Thread starter Eric D.
  • Start date Start date
E

Eric D.

Hi,

What is the maximum amount of characters you can use in
the Recordsource property of a form object?

I've got a 2600 char. SQL statement, but I can't set it to
the Recordsource of a form (even during runtime).

TIA,
Eric
 
Out of curiosity
How come you need an SQL of this magnitude?
The only sensible reason would in my opinion a *lot* of union statements -
if so break them up in seperate queries & union them in a final query. if
this is not the case you may have a redesigning job at hand
I don't remember exactly (and if it still holds) - but I think Access 2.0
had a max length of 255 chars per SQL Statement

HTH

Pieter
 
Back
Top