Unable to Open Products in Product Designer

Unable to Open Products in Product Designer

Symptoms

On trying to open a product using Product Designer, the system reports the file needs to be upgraded. Clicking OK to allow the upgrade, the system returns the following message:

Unable to open the file '...'. Check to make sure that the file is not in use and try again; (Code 30)"

Cause

This is caused when the Microsoft Jet database engine cannot open the required database file (product file). There can be many different causes that relate to this message. Review the resolutions below, trying each one until the problem is resolved.

Workaround

There is no known workaround at this time.

Resolution

Resolution 1

Verify you have write access to the folder where the product file is located.

  1. Click the Start button.
  2. Click My Computer.
  3. Navigate to the folder where the product file is located.
  4. From the File menu, click New, Text Document.
  5. Change the name of the file to "test file" and press Enter.

If you receive an error message at either step 4 or 5 then you probably don't have write access to this folder. That is typically caused by either a network share that is setup for read-only access or the user security on the server is configured for read-only access. Contact your systems administrator to change the access to read/write.

Resolution 2

Verify that the file is not marked as read-only.

  1. Click the Start button.
  2. Click My Computer.
  3. Navigate to the folder where the product file is located.
  4. Select the product that cannot be opened.
  5. From the File menu, click Properties.
  6. On the General tab, verify the Read-only check box is unchecked.
  7. Click OK.

Resolution 3

Install the latest version of the Jet 4.0 Engine. The file to download and the installation instructions are different for the various versions of Microsoft Windows. Refer to the following Microsoft document for information on downloading and installing the latest version of Microsoft Jet 4.0:

http://support.microsoft.com/kb/829558

Resolution 4

Install the latest version of the Microsoft Data Access Components (MDAC). The file to download andthe installation instructions are different for the various versions of Microsoft Windows. Refer to the following Microsoft document for information on downloading and installing the latest version of

MDAC:

http://www.microsoft.com/en-us/download/details.aspx?id=5793

The following article can be used for reference:

http://msdn.microsoft.com/en-us/library/ms810805.aspx

Note: MDAC is pre-installed on some versions of Windows and cannot be manually installed.

Applies To:

  • Product Designer 3.x
  • Product Designer 4.0
  • Product Designer 4.1
  • Product Designer 4.2
  • Solatech Window Covering Software, 3.x

    • Related Articles

    • Add Account Numbers to Products in Solatech Focus

      Summary Entering and saving account numbers for a vendor allows for electronic ordering directly from Solatech Focus to the vendor. In essence, the order is sent directly to the vendor and there is no need to build products a 2nd time in the ...

    • Unable to run more than one instance of Product Designer

      Symptoms When you attempt to run more than one instance of one of the applications listed at the bottom of this article, the first instance runs but the second does not. No error message is displayed. Cause The most likely cause is that your software ...

    • How to Check for Product Updates in SalesPro

      Summary This article will describe how to check for product updates from SalesPRO. Please note that this requires internet access. Instructions To check for product updates, navigate to the Maintenance tab. Click Product Updates. In the Product ...

    • How to use the Product Designer Inventory Assistant

      Summary This article explains how to use the Product Designer Inventory Assistant. More Information The Product Designer Inventory Assistant is a utility that can be used to perform functions that are not available in the Inventory Setup module of ...

    • Product designer runs but will not restore to a usable window; it stays on the taskbar

      Symptoms When Product Designer is run its icon will appear on the taskbar but it cannot be restored to a usable window. Cause This is caused when Product Designer is closed while it is minimized. This can occur while minimizing Product Designer and ...