Article ID: 241009 - Last Review: September 6, 2002 - Revision: 1.1

MOD2000: Error Message: "Object Variable or With Block Variable Not Set" Packaging an Access Project

This article was previously published under Q241009
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

On This Page

Expand all | Collapse all

SYMPTOMS

When you create a package for a Microsoft Access project (*.adp or *.ade) with the "Package and Deployment" Wizard, you may receive the following error message when you click Package on the first screen of the wizard:
Object variable or With block variable not set
When you click OK, the wizard continues successfully to completion without additional related errors.

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Developer Service Release 1 (SR-1).

To obtain SR-1, click the article number below to view the article in the Microsoft Knowledge Base:
253566  (http://support.microsoft.com/kb/253566/EN-US/ ) MOD2000: How to Obtain and Install Microsoft Office 2000 Developer Service Release 1 (SR-1)

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.  This problem was corrected in Microsoft Office 2000 Developer SR-1.

MORE INFORMATION

This error does not indicate any damage to the package or to your system. It has no effect on the operation of the "Package and Deployment" Wizard. You can continue to create and then distribute the package.

Steps to Reproduce the Behavior

NOTE: To complete the following steps, you must have either the Microsoft Data Engine (MSDE) installed or a connection to SQL Server.
  1. Start Microsoft Access and create a new Access project.
  2. Press ALT+F11 to open the Visual Basic Editor.
  3. On the Add-ins menu, click Package and Deployment Wizard.
  4. On first screen of the "Package and Deployment" Wizard, click Package. Note that you receive the error message mentioned in the "Symptoms" section.
  5. Click OK. The wizard continues with no further related errors.

REFERENCES

For additional information about distributing Access projects and MSDE, click the article number below to view the article in the Microsoft Knowledge Base:
240293  (http://support.microsoft.com/kb/240293/EN-US/ ) MOD2000: How to Deploy an Access Data Project That Includes the Microsoft Data Engine
For additional information about the error "Object variable or With block variable not set", click the article number below to view the article in the Microsoft Knowledge Base:
223229  (http://support.microsoft.com/kb/223229/EN-US/ ) Resetting Code in Visual Basic Editor Causes Problems with Wizards

APPLIES TO
  • Microsoft Office 2000 Developer Edition
Keywords: 
kbbug kbfaq kbpdwizard kbpending KB241009
 

Article Translations