RecordSource limited to 253 characters?

  • Thread starter Thread starter Wm
  • Start date Start date
W

Wm

Can anyone confirm that RecordSource is limited to 253 characters?

The symptom is Run-time error '2757': "There was a problem accessing a
property or method of the OLE object." I found the RecordSource truncated
at 253 characters which cut my select statment in half.

William
 
Wm said:
Can anyone confirm that RecordSource is limited to 253 characters?

The symptom is Run-time error '2757': "There was a problem accessing a
property or method of the OLE object." I found the RecordSource truncated
at 253 characters which cut my select statment in half.
Click to expand...


It's certainly much greater than that.

According to Access Help - Specifications the number of
characters in a RecordSource SQL statement is 32,750.
 
You're right Marshall. It appears that the Watch window cuts it off at 253
characters but when I used Debug.Print Me.RecordSource, the whole string is
there.

I moved much of my select statement into the Filter and OrderBy properties
and everthing is working so I still don't know what caused the original
problem. I won't have time to investigate unless it rears its ugly head
again.

Thanks for your help,
Wm
 
Back
Top