Microsoft KB Archive/875287

= Description of the &quot;RecordCount&quot; property, the &quot;NoConvertDialog&quot; property, and the &quot;Compiled State&quot; property and their possible values when viewed in the Access Conversion Report Tool =

Article ID: 875287

Article Last Modified on 7/28/2004

-

APPLIES TO


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

-



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

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



INTRODUCTION
This article describes the following Microsoft Access database properties that are represented as numbers:
 * The RecordCount property
 * The NoConvertDialog property
 * The Compiled State property

The article also describes possible values for these properties.



MORE INFORMATION
When you use the Microsoft Access Conversion Scanning Tool that is included with the Microsoft Office Access 2003 Conversion Toolkit, you can collect information about the following properties:
 * Data Access Objects (DAO) properties
 * File properties
 * Access properties

You collect this information for the Access databases on your network. The information that is collected by the Access Conversion Scanning Tool is stored in the log files on your computer in .xml file format. To view or to analyze the information that is collected by the scanning tool, use the Access Conversion Report Tool. The Access Conversion Report Tool displays this information in an easy-to-read format.

The following list describes some of the properties of your Access databases that are collected by the scanning tool. The properties are represented as numbers in the report tool. This list also provides information about the values for the properties and how to interpret the values for the properties.  RecordCount

The RecordCount property is a DAO property that indicates the number of records in a table in your Access database.

After you scan your database, you can view the RecordCount property of a table in your Access database. To do this, follow these steps :  Click Start, point to Programs, and then point to Microsoft Office Tools. Point to Microsoft Access Conversion Toolkit, and then click Access Conversion Report Tool. In the Main Menu form, click View DB Details in the Analyze Data section. In the View Database Details form, click Tables in the Database Objects section. In the Table Information section, locate the value of the RecordCount field.</ol>

Possible values and their meanings <ul> -1

This value of the RecordCount property of a table indicates that the table is a linked table in your Access database. To determine the actual number of records in the linked table, you must open the database manually and then analyze the linked table.</li>  

This value of the RecordCount property of a table indicates the actual number of records in the table.</li></ul> </li> Compiled State

The Compiled State property is an Access property of your database that indicates whether your Access database is fully compiled or not. To view the compiled state of your database, you must configure the Access Conversion Scanning Tool to collect the Access properties for your Access databases.

To view the Compiled State property of your Access database, follow these steps: <ol> Click Start, point to Programs, and then point to Microsoft Office Tools.</li> Point to Microsoft Access Conversion Toolkit, and then click Access Conversion Report Tool.</li> In the Main Menu form, click View DB Details in the Analyze Data section.</li> In the View Database Details form, click Database in the Database Objects section.</li> In the Database Information section, locate the value of the IsCompiled field.

Note The Compiled State property of the Access database is presented by the Access Conversion Report Tool as IsCompiled.</li></ol>

Possible values and their meanings <ul> 0

The Access database is not in a compiled state.</li> 1

The Access database is in a compiled state.</li> <Blank>

The compiled state of the Access database is not known. The IsCompiled field appears blank when the Access properties for the database are not collected by the Access Conversion Scanning Tool.</li></ul> </li> NoConvertDialog

The NoConvertDialog property is a DAO property of your Access database that indicates whether the Convert/Open Database dialog box appears or not when you open an Access 97 database in later versions of Access.

After you scan your database, you can view the NoConvertDialog property of your Access database. To do this, follow these steps: <ol> Click Start, point to All Programs, and then point to Microsoft Office Tools.</li> Point to Microsoft Access Conversion Toolkit, and then click Access Conversion Report Tool.</li> In the Main Menu form, click View DB Details in the Analyze Data section.</li> In the View Database Details form, click Database in the Database Objects section.</li> <li>In the Database Information section, locate the value of the No Convert Dialog field.

Note The NoConvertDialog property of the Access database is presented by the Access Conversion Report Tool as No Convert Dialog.</li></ol>

Possible values and their meanings <ul> <li>0

The NoConvertDialog property is set to False. Therefore, when you open the Access 97 database in later versions of Access, the Convert/Open Database dialog box appears.</li> <li>1

The NoConvertDialog property is set to True. Therefore, when you open the Access 97 database in later versions of Access, the Convert/Open Database dialog box does not appear.</li> <li><Blank>

The NoConvertDialog property is not set.

Note If you change the value of the NoConvertDialog property of your Access database while you are scanning your database by using the scanning tool, the value of the NoConvertDialog property that is reported by the report tool is the original value of the NoConvertDialog property. The original value of the NoConvertDialog property is the value of the NoConvertDialog property that existed before you changed the value by using the scanning tool.</li></ul> </li></ul>

<div class="references_section">