Article ID: 837150
Article Last Modified on 5/23/2007
APPLIES TO
- Microsoft Office XP Developer Edition, when used with:
- Microsoft Windows XP Service Pack 2
- Windows Vista Business
- Windows Vista Enterprise
- Windows Vista Ultimate
- Microsoft Windows Server 2003, Standard Edition (32-bit x86)
- Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
- Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
- Microsoft Access 2002 Standard Edition
This article applies only to a Microsoft Access database (.mdb).
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you try to install a Microsoft Access 2002 runtime deployment package on a computer that is running Microsoft Windows Server 2003, Microsoft Windows XP Service Pack 2 (SP2), or Windows Vista, the installation may not successfully finish. Additionally, you may receive the following error messages:
Error message 1
The following error message follows this error message:
Note This problem may not occur on your computer if Windows Server 2003 has been upgraded from a previously installed Windows operating system.
Error message 2
The following error message follows this error message:
CAUSE
This problem occurs becausethe Ospfilelist.txt file contains the wrong information about the following four files:
- Dbmsadsn.dll
- Msxml.dll
- Dbnmpntw.dll
- Sqloledb.dll
Microsoft Data Access Components 2.8 (also known as MDAC 2.8) is included with Windows Server 2003. Windows Data Access Components 6.0 (also known as Windows DAC) is included with Windows Vista. MDAC 2.8 and Windows DAC do not include the Dbmsadsn.dll file for the AppleTalk Net-Library. Additionally, the Dbmsadsn.dll file for AppleTalk and the Dbmsvinn.dll file for Banyan Virtual Integrated Network Service (VINES) are removed when you install Windows XP SP2.
WORKAROUND
To work around this problem, delete the line that contains the Dbmsadsn.dll file from the Ospfilelist.txt file. Then, change “All” to “9x” in the fourth column of the lines that contain the Msxml.dll file name, the Dbnmpntw.dll file name, and the Sqloledb.dll file name. Then, create the Access 2002 runtime deployment package. To do this, follow these steps:
- Locate the Packaging Wizard folder on the computer where the Access 2002 runtime deployment package was created.
By default, the Packaging Wizard folder can be found in the following location:Installation_Drive:\Program Files\Microsoft Office Developer\Packaging Wizard - Start Notepad, and then open the Ospfilelist.txt file.
Note Make a backup copy of the Ospfilelist.txt file. - In the Ospfilelist.txt file, locate and then delete the line that contains the Dbmsadsn.dll file.
- In the Ospfilelist.txt file, locate the three lines that contain the Msxml.dll file name, the Dbnmpntw.dll file name, and the Sqloledb.dll file name. Change the fourth column of each line from “All” to “9x.”
- On the File menu, click Save.
- On the File menu, click Exit.
- Create the Access 2002 runtime deployment package again by using the Packaging Wizard.
- Install the Access 2002 runtime deployment package on the computer that is running Windows Server 2003, Windows XP SP2, or Windows Vista.
Notice that the installation of the Access 2002 runtime deployment package is successfully completed.
MORE INFORMATION
The Msxml.dll file is no longer supported. This functionality has been included in versions of the Microsoft XML Parser that are included with Windows Vista.
For more information about the Microsoft XML Parser , click the following article number to view the article in the Microsoft Knowledge Base:
269238 List of Microsoft XML Parser (MSXML) versions
The Dbnmpntw.dll file and the Sqloledb.dll file are considered protected system files in Windows Vista. These files are not included in earlier versions of Windows. Windows Resource Protection prevents you from replacing these files. These files are included as part of Windows DAC.
For more information about Windows DAC, visit the following Microsoft Web site:
For more information about Windows Resource Protection, visit the following Microsoft Web site:
When you install Windows Server 2003 or Windows XP SP2 on your computer, MDAC 2.8 is also installed on your computer. However, MDAC 2.8 does not include the Dbmsadsn.dll file. Similarly, Windows DAC is included with Windows Vista. However, Windows DAC does not include the Dbmsadsn.dll file.
When you try to install the Access 2002 runtime deployment package, the Setup program determines whether the files that are mentioned in the Ospfilelist.txt file exist on your computer. The Setup program also determines whether the files that are mentioned in the Ospfilelist.txt file meet the minimum version requirements. The Setup program fails if it encounters any of the reasons that the "Cause" section mentions.
Steps to reproduce the problem
- Create an Access 2002 runtime deployment package for the Northwind.mdb sample database.
Note Make sure that the Access 2002 runtime deployment package includes the Access run-time files.
- Determine whether the computer is running Windows XP SP2, Windows Vista, or Windows Server 2003.
Note If the computer is running Windows Server 2003, make sure that Windows Server 2003 was not upgraded from a previously installed Windows operating system.
- Copy the Setup files for the Access 2002 runtime deployment package that you created in step 1. Put these Setup files on the computer that you identified in step 2.
- Install the Access 2002 runtime deployment package on the computer that you identified in step 2.
Notice that you receive the error messages that the "Symptoms" section mentions.
REFERENCES
For more information about how to create an Access 2002 runtime deployment package by using the Packaging Wizard in Microsoft Office XP Developer, visit the following Microsoft Developer Network (MSDN) Web sites:
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
838209 List of Microsoft Data Access Components (MDAC) fixes in Windows XP Service Pack 2 and in Windows XP Tablet PC Edition 2005
Additional query words: ACC2002 ACCXP package and deployment wizard
Keywords: kbprb kbsetup kbpackage kbdeployment kberrmsg kbpdwizard KB837150
