Unanswered: Character limit in source field of OpenRecordset?
I am running into an issue of the source portion of an OpenRecordset string. I have a sql query that is generated via code. Whenever the select statement grows over 256 Characters the function cuts off the statement at the 257th character and I get an error.
Any ideas on this, should I move my query statement into a querydef?