Microsoft KB Archive/875289

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

Article ID: 875289

Article Last Modified on 8/25/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.



INTRODUCTION
The Access Conversion Scanning Tool, also known as Adscanner.exe, is a program that can run at the command-line interface to scan Microsoft Access databases on a network, on a share, or on a desktop. The Adscanner.exe program collects file properties, Access properties, and Data Access Object (DAO) properties of Access databases. This program is included with the Microsoft Office Access 2003 Conversion Toolkit. The Adscanner.exe program is not an Access application. The Adscanner.exe program can run from a computer that does not have Access installed.

This article describes how to use the Adscanner.exe program at the command-line interface. This article also describes the following:
 * The correct way to use each command-line argument for the Adscanner.exe program
 * The default settings for the command-line arguments for the Adscanner.exe program



MORE INFORMATION
By default, the Adscanner.exe program is stored in the following folder:



Note The placeholder  is a placeholder for the drive letter where the installation of the Office Access 2003 Conversion Toolkit is located.

You can run the following command at the command prompt to see the usage information for the Adscanner.exe program. adscanner /? When you run the previous command, usage information that is similar to the following appears:

adscanner ResultPath [/sourcepath SourcePath] [/dao:off] [/acc:on] [/com:off] [/noconvdlg:[on|off]] [/maxcopy Size] [/temppath TempPath]

Each command-line argument that is mentioned in the usage information shows the possible settings for the specified command-line argument. There are eight possible command-line arguments for the Adscanner.exe program. The following list describes the details about the command-line arguments:  ResultPath

This command-line argument is required. You use this command-line argument to specify the folder where you want to store the results of the scan. The Adscanner.exe program creates one .xml file for each database that is scanned.

Notes  If you specify the path of an .xml file for this command-line argument, make sure that you only specify a single database to scan in the SourcePath command-line argument.  If the ResultPath command-line argument contains spaces, you must enclose the path in double quotation marks. The following sample code demonstrates this: adscanner &quot;C:\Program Files\Microsoft Office\Conversion Toolkit\res&quot;   [/sourcepath SourcePath]

This command-line argument is optional. You can use this command-line argument to specify the location that you want to scan for Access databases. You can specify a specific drive letter, a Universal Naming Convention (UNC) share path, or a specific database file. When a drive letter or a UNC is specified, that respective folder and all the subfolders are scanned for Access databases. If you do not specify this command-line argument, the Adscanner.exe program scans all the local hard drives for Access databases.

Note If you do not specify this command-line argument, the Adscanner.exe program does not scan the mapped drives on your computer. [/dao:off]

This command-line argument is optional. You can use this command-line argument to specify that the Adscanner.exe program must not collect the DAO properties from the Access databases that are scanned. If you do not specify this command-line argument, the Adscanner.exe program collects the DAO properties from the Access databases. [/acc:on]

This command-line argument is optional. You can use this command-line argument to specify that the Adscanner.exe program must collect the Access properties from the Access databases that are scanned. To collect the Access properties, you must run the Adscanner.exe program on a computer that has Access 95 or later installed. If you do not specify this command-line argument, the Adscanner.exe program does not collect the Access properties from the Access databases.</li> [/com:off]

This command-line argument is optional. You can use this command-line argument to specify that the Adscanner.exe program must not collect the computer properties for the Access databases that are scanned. If you do not specify this command-line argument, the Adscanner.exe program collects the computer properties for the Access databases.</li> [/noconvdlg:[on|off]]

This command-line argument is optional. You can use this command-line argument to set the NoConvertDialog property for the databases that are scanned by the Adscanner.exe program. If the NoConvertDialog property is set to &quot;Yes,&quot; Access prevents the conversion dialog box from appearing when you open a version of an Access database that is earlier than Access 2002 or Access 2003 in either Access 2002 or Access 2003.

If you set this property for an Access database, the LastModified date of the Access database changes. If you do not specify this command-line argument, the Adscanner.exe program leaves the NoConvertDialog property as &quot;uncreated&quot; in the Access databases.</li> [/maxcopy Size]

This command-line argument is optional. You can use this command-line argument to specify the maximum file size in megabytes (MB) that you want to let the scanner copy for the collection of Access properties.

When the Adscanner.exe program collects the Access properties, the Adscanner.exe program makes a copy of each database that will be scanned and then opens the copy. You do this to preserve the LastModified date for the database. You can use this setting to limit the file size that is copied. If you do not specify this command-line argument, the Adscanner.exe program uses a default-file size of 50 MB.</li> [/temppath TempPath]

This command-line argument is optional. You can use this command-line argument to specify a folder path. Before the Adscanner.exe program collects the Access properties of the Access databases, the Adscanner.exe program copies the Access databases to this folder path. You may specify a drive letter or a UNC path. If you do not specify this command-line argument, the Adscanner.exe program uses the folder path that is specified for the TEMP variable in the Microsoft Windows operating system that is running on your computer.</li></ul>

<div class="references_section">