The Access Conversion Scanning Tool does not collect Access properties information for Access databases (875288)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Access 2000
  • Microsoft Access 97
  • Microsoft Access for Windows 95

This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

The Access Conversion Scanning Tool (Adscanner.exe) is included with the Microsoft Office Access 2003 Conversion Toolkit. The Access Conversion Scanning Tool is designed to collect information about the Access databases on your computer. When you run the Access Conversion Scanning Tool, you may notice that the Access Conversion Scanning Tool does not collect information that corresponds to the Microsoft Access properties for the Access databases on your computer.

This problem occurs although you specify the /acc:on command-line argument when you start the Access Conversion Scanning Tool at the command prompt.

Note The /acc:on command-line argument explicitly indicates that the Access Conversion Scanning Tool must collect information about the Access properties for the Access databases that are on your computer.

CAUSE

This problem occurs if an incorrect version of Access is installed on your computer that is running the Access Conversion Scanning Tool.

This problem also occurs if Microsoft Access is not installed on your computer that is running the Access Conversion Scanning Tool.

RESOLUTION

To collect information about the Access properties for the Access databases on your computer, the Access Conversion Scanning Tool requires that Microsoft Access 95 or later is installed on your computer. Therefore, you must use one of the following methods to resolve this problem:
  • Install Microsoft Access 95 or later on your computer that is running the Access Conversion Scanning Tool.
  • Run the Access Conversion Scanning Tool from a computer that already has Microsoft Access 95 or later installed.

MORE INFORMATION

The Access Conversion Scanning Tool that is included with the Microsoft Office Access 2003 Conversion Toolkit scans the disks on your computer and collects detailed information about your Access databases. By using the Access Conversion Scanning Tool, you can collect the following information about your databases and the objects that are in your databases:
  • The file properties
  • The Access properties
  • The Data Access Object (DAO) properties
After you run the Access Conversion Scanning Tool, you may notice that the Access properties for some databases appear. However, the Access properties for other databases do not appear. This means that you may have encountered some other conditions that prevent the Access Conversion Scanning Tool from collecting information that corresponds to the Access properties for Access databases. These other conditions are reported as errors in the report tool.

Note For additional information about these other conditions that prevent the Access Conversion Scanning Tool from collecting Access properties from an individual Access database, see the Access Conversion Toolkit documentation.

After your databases are scanned for Access properties, you can view the errors that occurred for these other conditions. To do this, follow these steps :
  1. Click Start, point to Programs, and then point to Microsoft Office Tools.
  2. Point to Microsoft Access Conversion Toolkit, and then click Access Conversion Report Tool.
  3. On the Main Menu form, click View DB Details under the Analyze Data section.
  4. On the View Database Details form, click Errors under the Database Objects section.
Note If the Access properties for the scanned databases are not collected by the Access Conversion Scanning Tool because the incorrect version of Microsoft Access is installed on your computer or because Microsoft Access is not installed on your computer, you can see any errors that are reported in the report tool. If you open the tblErrors table in the Access Conversion Report Tool database, you can see that you receive the following error message in the Error field of the tblErrors table:
Access properties option was selected, however Access was not present on the machine.
Note Capitalization, punctuation, and words in the previous error message match what appears on the UI.

Steps to reproduce the problem

  1. Download and install the Microsoft Office Access 2003 Conversion Toolkit on a computer that does not have Microsoft Access 95 or later installed.

    For additional information about how to download the Microsoft Office Access 2003 Conversion Toolkit, visit the following Microsoft Web sites:

    Toolbox

    http://www.microsoft.com/office/ork/2003/tools/default.htm

    Microsoft Office Access 2003 Conversion Toolkit

    http://www.microsoft.com/office/ork/2003/journ/accessconvert.htm

  2. Start the command prompt.
  3. Locate the folder that contains the scanning tool that is named Adscanner.exe.

    By default, the Adscanner.exe file is stored in the following folder:

    <InstallationDrive>:\Program Files\Microsoft Office\Conversion Toolkit
  4. Run the following command at the command prompt:
    Adscanner.exe <ResultPath> /acc:on
    When you run the previous command at the command prompt, Adscanner.exe collects information about the Access properties for your Access databases.

    Note The <ResultPath> placeholder is a placeholder for the full path of a folder on your computer where the Access Conversion Scanning Tool stores the collected information about the databases and the database objects. The collected information is stored as XML files. Before you run the previous command, you must make sure that the folder exists on your computer.
  5. Import the log files that contain information about the databases and the database objects in the Access Conversion Report Tool.

    When you view the results for the scanned databases, you notice that the Access properties for your Access databases are not collected by the Access Conversion Scanning Tool.

REFERENCES

For additional information about how to correctly use the Access Conversion Scanning Tool that is named Adscanner.exe and the errors that may occur when your Access databases are scanned, see the Microsoft Office Access 2003 Conversion Toolkit documentation.

To open the Microsoft Office Access 2003 Conversion Toolkit documentation, follow these steps:
  1. Click Start, point to Programs, and then point to Microsoft Office Tools.
  2. Point to Microsoft Access Conversion Toolkit, and then click Conversion Tool Documentation.
For additional information about how to use the Access Conversion Scanning Tool, click the following article number to view the article in the Microsoft Knowledge Base:

875289 Description of how to run the Access Conversion Scanning Tool at the command-line interface

Modification Type:MajorLast Reviewed:8/13/2004
Keywords:kbProperties kbtshoot kbDatabase kbdisplay kbprb KB875288 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.