Microsoft KB Archive/875288

= The Access Conversion Scanning Tool does not collect Access properties information for Access databases =

Article ID: 875288

Article Last Modified on 8/13/2004

-

APPLIES TO


 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition
 * Microsoft Access 97 Standard Edition
 * Microsoft Access 95 Standard Edition

-



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
 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

 Start the command prompt. 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:

:\Program Files\Microsoft Office\Conversion Toolkit  Run the following command at the command prompt: Adscanner.exe  /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  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. </li> 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.</li></ol>

<div class="references_section">