 |
 | 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 / April 2004Runtime error 5922 on Mailmerge
On trying to use the ActiveDocument.Mailmerge.OpenDataSource command on a CSV file, on a particular Windows 2000 computer I get Runtime Error 5922 Unable to open datasource The thing is the code works fine on another Win 2000 computer. My suspicion is something to do with permissions / security, but since I cannot even lookup what error 5922 actually means, because the System Error codes finish at 5907, this does not help me. The permissions on the file / folder are set to everyone full control, and the file is created programatically by the same user OK. Does anyone know what 5922 unable to open Datasource actually means, and more importantly how to fix it? I dont know what has happened to my posting of this on the application.errors newsgroup, as cannot find it there, although Google Groups does find it even with a reply from Kevin JF. Sorry if I was not supposed to double post, but I did not know about these rules, anyway. In response to Kevin JF's suggestion. ID does not feature in the field names anywhere in my csv. I wonder if anyone has got any other ideas, why VBA mailmerge open datasource method works on one windows 2000 machine but not another? >-----Original Message----- >On trying to use the [quoted text clipped - 19 lines] >actually means, and more importantly how to fix it? >. Sorry for the late reply but... A possible reason for the difference in behaviour could be that one machine has ODBC installed/enabled and the other does not. Could be worth having a look at the ODBC configuration, and/or changing the filename extension or having a look to see if there is a SCHEMA.INI file in the same folder as your csv file.  SignaturePeter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > On trying to use the > ActiveDocument.Mailmerge.OpenDataSource command on a CSV [quoted text clipped - 17 lines] > Does anyone know what 5922 unable to open Datasource > actually means, and more importantly how to fix it?
|
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.