Re: Mail Merge to Word 2007 from Access 2000

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

Amy wrote:
Thank you Peter for the clarification on the article.

For the answers to your questions:
a. can you open the database successfully in Access 2007 (if you have it? I do not have Access 2007 but I can successfully open the database in Access 2000 which is what we use.
b. Does your database have a password or a workgroup security file? Yes, I believe so - our original IT Manager who is no longer here and did not leave any info on this database (ugh) set it up that when you click on Access, it prompts you for a login and password and the the database automatically opens.
c. Has your Windows system been upgraded as well as your Office system? If so, which version are you using now? No we are still on Windows XP.
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) ? Yes but gave us errors because we needed to login. I always have to have Access open first with the database and then the Word merge form. In Word 2007, it is not opening successfully. I tried DDE and ODBC but with you info above, now I know that it is DDE. I get errors either way.
"Peter Jamieson" wrote:

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 wrote:
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.


"Doug Robbins - Word MVP" wrote:

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" <Amy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FEF1425B-C249-48B7-8044-F82A2C9A76F2@xxxxxxxxxxxxxxxx
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?




.

Loading