Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge to Word 2007 from Access 2000
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge to Word 2007 from Access 2000
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" wrote in message ... 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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge to Word 2007 from Access 2000
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" wrote in message ... 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? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge to Word 2007 from Access 2000
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" wrote in message ... 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? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge to Word 2007 from Access 2000
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" wrote in message ... 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? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
Can not use MS Access 2002 as a datasource for word 2000 mail merge | Mailmerge | |||
Using Mail Merge in Word 2003 with Access 2000 | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge |