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

ID: Q241009

The information in this article applies to:

Microsoft Office 2000 Developer

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

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.

Start Microsoft Access and create a new Access project.

Press ALT+F11 to open the Visual Basic Editor.

On the Add-ins menu, click Package and Deployment Wizard.

On first screen of the "Package and Deployment" Wizard, click Package. Note that you receive the error message mentioned in the "Symptoms" section.

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:

Q240293 MOD2000: How to Deploy an Access Data Project That Includes the Microsoft Data Engine

Additional query words: pra

Keywords : kbdta modPDWizard
Version : :
Platform :
Issue type : kbbug