Microsoft Knowledge Base Email Alertz

KBAlertz.com: (875288) - Describes that the information about Access properties for Access databases may not be collected by the scanning tool. This problem occurs when the computer does not have the correct version of Access installed. Install the correct version of Access.

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **


Bug Tracking Software
For bug tracking software or defect tracking software or issue tracking software, visit Axosoft.


Community Site



We Send hundreds of thousands of emails using ASP.NET Email



Expert Web Design & Graphic Design
Design44.com

ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Article ID: 875288 - Last Review: August 13, 2004 - Revision: 2.2

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


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

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

On This Page

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 (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 (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  (http://kbalertz.com/Feedback.aspx?kbNumber=875289/ ) Description of how to run the Access Conversion Scanning Tool at the command-line interface

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
Keywords: 
kbproperties kbtshoot kbdatabase kbdisplay kbprb KB875288
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Be the first to leave feedback, to help others about this knowledge base article.

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please