Mail Merge to Word 2007 from Access 2000

[Amy]

We have a very detailed merge into form fields in word from a database in
Access. Works fine, however, we just recently were updated to Office 2007
but we did not get updated in Access. All Access databases are NOT being
found when we try to accomplish the merge. I have spent hours researching
with no success. The message is:
<Document Name> is a mail merge main document. Word cannot find it's data
source. (<pathname>/<Document Name>)

When I try to repoint the database I get security erros saying I do not have
permission.

Please - anyone?

 

[Doug Robbins - Word MVP]

From the Office button in Word, select Word Options and then Advanced and
scroll down to the General section of the dialog and check the box against
the "Confirm file format conversion at open" item. After doing that, when
yoy go to attach the data source to the mail merge main document, a dialog
box will appear in which you can select the method by which the connection
should be made. Try the DDE option.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Amy]

I hope this is where I need to reply correctly. Thank you for your
suggestion. I tried this and it did not work - it gave me an error the
suggesting I go to Article ID: 918594. It suggested I change the "customize"
under word options to add Database - this didn't seem to change anything.

I tried under the ODBC as well - and I get a admin rights error there. I
have full admin rights - dang - what am I missing?
A.

 

[Peter Jamieson]

The article you reference is about using the "Insert Database" command,
which is related but different from trying to connect to a mail merge
data source.

A few questions...
a. can you open the database successfully in Access 2007 (if you have it?
b. Does your database have a password or a workgroup security file?
c. Has your Windows system been upgraded as well as your Office
system? If so, which version are you using now?
d. When you used to open your mail merge main document in Word 2000,
did Access open (which would mean you had a DDE connection), or not
(which would mean you had an ODBC connection) ?

Peter Jamieson

http://tips.pjmsn.me.uk

 

[Amy]

Thank you Peter for the clarification on the article.

For the answers to your questions:

 

[Peter Jamieson]

Hello Amy,

OK, unfortunately Word 2007+Access 2000 (i.e. the program, rather than
the format) isn't a combination I am currently in a position to test
here, but
a. if you go the route that Doug suggested, of specifying DDE, then
trying to open the data source, do you ever see that login dialog box?
If not, it could be that the box is being displayed /behind/ the Word
window, and if you alt-tab you will see it and be able to respond to it.
The same may be true if you are trying to connect to a "parameter query"
where you have to enter some values before Access runs the query. This
behaviour changed a long time ago now and it could well have been after
Office 2000
b. if your data source is a table in Access, or a query that is not a
parameter query, and a few other "if"s, you may be able to connect using
OLE DB, which is the current standard and may work around many of these
problems. However, to do that with a database that has a login/password,
you will need to set up an "Office Data Connection" file (.odc file)
that contains the necessary info. But let's go into the details if we
need to.

Peter Jamieson

http://tips.pjmsn.me.uk