No records found / Connection to ACCESS query or table

[Eric]

I am running ACCESS and WORD 2002 and having problems
merging to an ACCESS query or table. In Access the query
accuratley shows the records with all the data that needs
to be used in the merge, however, when I try to make the
connection through merge wizard I get an error. 'Record 1
contains too few data fields' then 'Record 2 contains too
few data fields'. These error messages occure several
times in closing out the error window. Also, when I try
to connect to a table in ACCESS I sometimes get a message
stating that the 'the table contains no data'. I know
this can't be the case because I can view the data in
ACCESS. The data is somehow getting lost in the
connection. Please help. Eric

 

[Cindy M -WordMVP-]

Hi Eric,

The first thing to check would be whether the problem occurs
when using a different technology to connect in the data. In
the Word 2002 section of my website's mail merge FAQ you
should find an entry about using older connection
techniques. Try DDE and ODBC. Does either (or both) give you
correct results?

I am running ACCESS and WORD 2002 and having problems
merging to an ACCESS query or table. In Access the query
accuratley shows the records with all the data that needs
to be used in the merge, however, when I try to make the
connection through merge wizard I get an error. 'Record 1
contains too few data fields' then 'Record 2 contains too
few data fields'. These error messages occure several
times in closing out the error window. Also, when I try
to connect to a table in ACCESS I sometimes get a message
stating that the 'the table contains no data'. I know
this can't be the case because I can view the data in
ACCESS. The data is somehow getting lost in the
connection.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail