Word unable to open the Data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jp - 09 Dec 2003 16:16 GMT

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?

Reply to this Message

Peter Jamieson - 09 Dec 2003 17:08 GMT

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.

--
Peter Jamieson - Word MVP

> 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?

Reply to this Message