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


The information in this article applies to:

  • Microsoft Office 2000 Developer
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).

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 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 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 Resetting Code in Visual Basic Editor Causes Problems with Wizards

Modification Type:MajorLast Reviewed:9/6/2002
Keywords:kbbug kbPDWizard KB241009
©2002 Microsoft Corporation. All rights reserved.