By: Quinn Wildman
Abstract: DAO and ODBC both impose this limit.
The reason the ODBC driver error occurs is because the Access ODBC driver has a limit of 255 characters for parameters.
The reason the error occurs with the Native driver is the DAO limits parameters to 255 characters and the BDE uses the Microsoft DAO client to use Access tables.
The best workaround to this problem is to use ADO with Delphi 5.
Another partial solution is to use a TQuery with requestlive=true, or a TTable.
Try Delphi XE4 free for 30 days
New Instant Trial!
Webinars on demand!
More social media choices:
Delphi on Google+
@RADTools on Twitter
Server Response from: ETNASC02