Limitations in MS Query?

J

Jonas Lundqvist

This message was originally posted in the Word-discussion group, but I was
recommended to post it here instead:

I have a Word-document that collects data from a database through MS Query
and joins them to a letter.
This has been working very well until just recently. It seems that if a
field in the database contains a very long text MS Query is unable to handle
the data. In my example a field in the database containing 42219 characters
in 595 rows causes MS Query to crash.

Does anyone know the exact number of characters or rows that is the maximum
content in a field in MS Query?

I will need to redesign my database and it would be very helpful if I could
get the exact number instead of doing trial and error.
 

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

Similar Threads

Limitations in MS Query? 1
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
add mergefields to exsting word 2013 2
Limiting size field MS query returns 0
Limit using pivot table with Access database? 1
Maximum Fields in MS Query 0
Formatting Numeric Fields from Within MS Query 1
MS Query 4

Top