Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    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?
    Last edited by ageiger; 01-27-03 at 16:21.

  2. #2
    Join Date
    Nov 2002
    I have used the following methods to reduce a SQL string size.

    Use a table alias:
    SELECT T.Field1, T.Field2 FROM tblTable1 AS T

    If pulling all the fields use:
    SELECT T.* FROM tblTable1 AS T

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts