Word unable to open the Data source

[jp]

I am pulling data via ms query over an AS/400 file. this worked fine
yesterday with a small file but is not working now that i am pulling fields
from a larger file.. is there some sort of a limit to the file size of the
data source?

on is there a way to id the problem from the error message?

 

[Peter Jamieson]

A possibility is that there is a problem with the length of the SQL query
string - if it is over about 255 characters, or over about 512 characters,
Word will probably truncate the string that MS Query hands back to it. You
can have a look using the SQL button in MS Query and estimate the query
length. Although you /may/ be able to fix this by modifying the query text
in MS Query (e.g. to SELECT * FROM (whatever), or by shortening the table
aliases in the query) I have a feeling that you may end up having to create
a bit of VBA containing an OpenDataSOurce statement and modifying the SQL in
that directly.