Consider the following scenario. You develop an application in Microsoft Office Access 2003 or in Microsoft Access 2002. You create an installation package for the application by using either the Package Wizard that is included with Microsoft Office Access 2003 Developer Extensions or the Packaging Wizard that is included with Microsoft Office XP Developer Edition. In this scenario, the wizard uses the run-time files that are included with the release version of Access, even though you installed Office service packs and other Office software updates. The wizard does not use the updated files.
The installation package is always built from the run-time files that are included with the release version of Access and from the setup files that are found on the Office CD or on the Access CD. You must apply the updates to these files after you install the run-time application. You apply the updates on the client computer directly or through the setup script that is described in the "Workaround" section.
To work around this behavior, use the following method that corresponds to the version of Access that you are using.
Method 1: Microsoft Office Access 2003
To make sure that the updated files in Access 2003 are used when you create an installation package, follow these steps:
Download and save the latest Microsoft Office 2003 service pack. To obtain Microsoft Office 2003 Service Pack 2 (SP2), visit the following Microsoft Download Center Web site:
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
Copy the file that you downloaded in step 1 to the Files folder of the installation package for the application that you developed. For example, copy the Office2003SP2-KB887616-FullFile-ENU.exe file to the Files folder.
In Notepad, open the Setup.ini file from the Files\Setup folder of the application.
Add the following lines of code to the end of the Setup.ini file.
[ChainedInstall_1]; Chain the installation for Office2003 SP2 Full-File software updatePath="\Files\Office2003SP2-KB887616-FullFile-ENU.exe"TaskType=EXECmdLine=/q:a
Note If you did not download the Office2003SP2-KB887616-FullFile-ENU.exe file in step 1, replace "Office2003SP2-KB887616-FullFile-ENU.exe" in this code with the name of the file that you downloaded in step 1.
Save the Setup.ini file.
Method 2: Microsoft Access 2002
To make sure that the updated files in Access 2002 are used when you create an installation package, follow these steps:
Download and save the appropriate software updates to a local folder. For example, download the following software updates that correspond to the version of Access that you are using, and then save them to the C:\Updates folder:
To obtain Update for Access 2002 (KB904018), visit the following Microsoft Download Center Web site:
Note Download and save the OfficeXpSp3-kb832671-fullfile-enu.exe file. Office XP SP3 is required if Office XP is installed on the client computer. If Office XP is not installed on the client computer, this service pack is not required.
Start Notepad, and then create a batch file by typing the following lines in a new text document.