 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2007Import from Access 2007 Query
When I try to do a mail merge using an Access 2007 Query that contains parameters, the import fails. I get a dialogue box in word (2007) titled "ODBC Microsoft Access Driver Login Failed" with the information "Could not find file 'blah, blah, blah.mdb' contained in the body of the dialogue box. The file referenced in the dialogue box IS NOT the database I'm pulling the data from. I migrated this db from Access 95 to Access 2007....it's looking for the old db???? Is there something I can do about this? This does not occur when I import queries that don't contain parameters. To use a parameter query as a data source, use the old DDE connection method to connect to Access. If you were using any version of Word prior to XP/2002 previously, that would have been the default method. To use DDE in Word 2007, clcik the Office button, Word Options, Advanced, General and check "Confirm file format conversion on open". Then go through the process of selecting your database again and select the DDE option in the extra dialog box you see. I think that is the problem in this case, anyway. > The file referenced in the > dialogue box IS NOT the database I'm pulling the data from FWIW, Word 2007 seems to use temp files when dealing with data source rather more than previous versions did, and I'm wondering whether that is why you are seeing a different file name. Peter Jamieson > When I try to do a mail merge using an Access 2007 Query that contains > parameters, the import fails. I get a dialogue box in word (2007) titled [quoted text clipped - 9 lines] > > This does not occur when I import queries that don't contain parameters. Thanks for the suggestion. I tried it, and I'm still stuck. Had no problems finding teh "Confirm file format conversion on open." checked it -- never saw the extra dialog box that would allow me to select the DDE option. I got a dialog box titled "confirm data source" with the body text "Open Data Source: OLE DB Database Files" (ok or cancel). When I click ok, I see many of the tables and queries from my db -- but none of the queries that have parameters. > To use a parameter query as a data source, use the old DDE connection method > to connect to Access. If you were using any version of Word prior to XP/2002 [quoted text clipped - 28 lines] > > > > This does not occur when I import queries that don't contain parameters. OK, at this point > I got a dialog box titled "confirm data source" you probably also need to check the "show all" box and look for "MS Access Databases via DDE" Peter Jamieson > Thanks for the suggestion. I tried it, and I'm still stuck. Had no > problems finding teh "Confirm file format conversion on open." checked [quoted text clipped - 48 lines] >> > This does not occur when I import queries that don't contain >> > parameters. OK, found the "MS Access Databases via DDE" selected it, and clicked ok. Got the same dialog box "ODBC Microsoft Access Driver Login Failed" Could not find file C\Users\MicheleSwitzer\Documents\MSNA\Database.mdb." FYI, the file referenced in the dialog box is NOT the Access 95 db I migrated to Access 2000. > OK, at this point > [quoted text clipped - 57 lines] > >> > This does not occur when I import queries that don't contain > >> > parameters. Just to be sure: a. what is the pathname of the file you /are/ trying to use b. are you definitely selecting it in the step before you see the Confirm data source dialog box? I will have to take another look at this as well. Peter Jamieson > OK, found the "MS Access Databases via DDE" selected it, and clicked ok. > Got [quoted text clipped - 75 lines] >> >> > This does not occur when I import queries that don't contain >> >> > parameters.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.