Hit the RecordSource string limit in an Access 2000 Project Form
Posted on 2003-11-19
I've written some code which compiles an SQL statement depending on user parameters etc, only problem is that in some stiutations when I apply the SQL string to a form's RecordSource property to display the results I get the error, 'Setting for this property is too long'.
What's the best option(s) for getting around this ?
Back end is SQL server 2000.