Max Length of ADO Recordset Source property
Posted on 2004-08-18
Does anyone know if there is a maximum length of the source property of an ado recordset.
If there is, what is the maximum length, and does anyone have a way of working around this.
I have a search form in which the user can enter criteria into a lot (40+) fields. Needless to say, the SQL query text can become quite long, and I seem to be having a problem if the query string is too long, am getting an error
"7874 : Microsoft Access can't find the object 'Recordset.'"
Thanks in advance for any assistance!