Data truncation on query from MS Word

L

L.A. Little

I have some code that I have dusted off after a couple
years. The code used to work fine on MS Access 98 and Word
98 but now in a Word 2000 and MS Access 2000 environment,
it doesn't. The problem is that a query issued from macro
code in Word retrieves the data that it is intended to
retrieve, but it truncates the memo field to 255
characters.

I've looked around to see if I could figure out where the
truncation is occurring. Running the query in Access is
fine so it appears to be somewhere between MS Word and MS
Access. I'm using an Access 2000 ODBC driver to perform
the connectivity.

Any thoughts appreciated.

Les
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top