- Created by Suchi Govindarajan, last modified by MartinW on May 25, 2018
https://help.myob.com/wiki/x/zQR3AQ
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
These instructions require technical expertise
Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.
Article ID: 23409
ARTICLE LAST UPDATED: 30/01/2013 2:23:00 PM
In MYOB Accountants Office Classic you may experience the error "1429/OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source" when attempting to use templates.
This error can occur if an incorrect version of the Microsoft Visual Fox Pro driver is installed.
This error may also occur when using or creating templates on a computer running an installed program that uses the Borland Database Engine (BDE). Examples of programs that we have found to require the BDE are, BGL - Corporate Affairs System, CashManager and Visiplan, but undoubtedly there are others.
Please follow the following suggestions in the recommended order as displayed.
Download and install VFPODBC.msi on the affected workstation to reinstall the ODBC drivers.
The procedure below contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, refer to the Microsoft Knowledge Base article Q256986 Description of the Microsoft Windows Registry.
Exit from any open programs.
From the Start menu, select Run. The Run window appears.
Type regedit in the Open field and click OK. The Registry Editor window appears.
Double-click the HKEY_LOCAL_MACHINE folder.
Double-click the Software folder.
Double-click the Microsoft folder.
Double-click the Jet folder.
Double-click the 4.0 folder.
Double-click the Engines folder.
Double-click the Xbase folder.
- If you see the BDE value in the right window pane, go to step 15, otherwise continue with the next step.
From the Edit menu, select New, and choose DWORD Value. A new value with the temporary name of New Value #1 appears in the right window pane.
Click the New Value #1 value, and select Rename from the Edit menu.
Change the name to BDE.
Double-click BDE to open it. The Edit DWORD Value window appears
Click the Decimal radio-button at the Base section.
Type 2 in the Value data field and click OK.
- From the Registry menu, select Exit.
If the procedure above doesn't resolve the issue, follow the procedure below.
If the BDE-based program isn't required, uninstalling it will resolve the issue. If the BDE-based program is required, move the file named IDR20009.DLL, which is located in the C:\Windows\IDAPI folder, to the appropriate BDE-based program folder. For example:
- If BGL - Corporate Affairs System is the only BDE-based program, move the IDR20009.DLL file from the C:\Windows\IDAPI folder to the BGL - Corporate Affairs System program folder.
If BGL Simple Fund is installed in addition to the BGL - Corporate Affairs System, copy the IDR20009.DLL file into the BGL Simple Fund program folder and move the IDR20009.DLL file from the C:\Windows\IDAPI folder to the BGL - Corporate Affairs System folder.
If CashManager is the only BDE-based program, move the IDR20009.DLL file from the C:\Windows\IDAPI folder to the CashManager program folder, with the default folder being C:\Cashwin.
If you have previously moved the IDR20009.DLL file and the BDE-based program is upgraded, another IDR20009.DLL file is installed in the C:\Windows\IDAPI folder. In this instance, delete the IDR20009.DLL file from the C:\Windows\IDAPI folder.
MYOB INTERNAL STAFF ONLY
INTERNAL NOTES
This may still be relevant with Microsoft Vista and Word 2007.
Reinstalling the Microsoft Visual Fox Pro driver 5 may also resolve.