This article was previously published under Q137076
This article has been archived. It is offered "as is" and will no longer be updated.
When you use the Mail Merge or the Insert Database command to obtain datafrom a Microsoft Access data file, the option for "MS Access Databases(*.mdb)" does not appear in the "Files Of Type" list, and the DDE method ofobtaining the data is not available.
In addition, you may receive the following error message:
Word could not re-establish a DDE connection to Microsoft Access to complete the current task
For Word to show *.mdb files or to use DDE with Microsoft Access, theMicrosoft Access program folder must be listed correctly in the WindowsRegistry Extensions key. A Typical installation of Microsoft Access updatesthe Win.ini file with extension information, but information in the Win.inifile is not added to the appropriate Registry key in Windows 95.
Method 1: Add Microsoft Access to the Environment path
On the File menu, click Open.
In the File Name box, type c:\autoexec.bat. Click OK.
If the file is not found, click Cancel and type the following
PATH=<path to Access folder>
where <path to Access folder> is the location of your Microsoft Access folder. For example:
On the File menu, click Exit. When asked if you want to save changes, click Yes.
In the File Name box, type c:\autoexec.bat.
In the Save As Type box, choose "Text Document--MS-DOS Format."
Click OK. Exit WordPad. Skip to step 7.
Find the line that begins with PATH.
Place the insertion point at the end of this line. Type a semicolon (;) and the path to the Microsoft Access program folder.
Save the file and exit WordPad.
Restart the computer.
Word should now be able to show *.mdb files and to use DDE.
NOTE: If these steps do not correct the problem, make sure that thedatabase you are trying to connect to in the mail merge main document is inthe Access directory or in a directory in the path statement of theAutoexec.bat file.
Method 2: Correct the Registry
For information about how to edit the registry, view the Changing Keys AndValues online Help topic in Registry Editor (Regedit.exe). Note that youshould make a backup copy of the registry files (System.dat and User.dat)before you edit the registry.
WARNING: Using Registry Editor incorrectly can cause serious problems thatmay require you to reinstall Windows 95. Microsoft cannot guarantee thatproblems resulting from the incorrect use of Registry Editor can be solved.Use Registry Editor at your own risk.
Click the Windows Start button and click Run. In the Open box, type Regedit. Click OK.
Open HKEY_CURRENT_USER and open the following key: