Knowledge Base

ACC2000: Select Data Source Dialog Reads Floppy and CD-ROM Drives Repeatedly

Article ID: 201268

Article Last Modified on 7/13/2004

APPLIES TO

This article was previously published under Q201268
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

While choosing an ODBC datasource to link to, import from, or export to, you may see your computer's A, B, and CD-ROM drives read repeatedly.

CAUSE

In the ODBC Datasource Administrator, the default directory on the File DSN tab is set to My Computer.

RESOLUTION

To resolve this issue, follow these steps:
  1. In Microsoft Windows, click Start, point to Settings, and then click Control Panel.
  2. Double-click ODBC Data Sources.
  3. Click the File DSN tab.
  4. Under Look in, change the default directory to the following:

    Program Files\Common Files\ODBC\Data Sources\

    NOTE: The Program Files directory is usually on the same drive where Microsoft Access 2000 is located.
  5. Click Set Directory, and then click OK.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open a Microsoft Access database or Microsoft Access project.
  2. On the File menu, point to Get External Data, and then click Import or Link Tables.
  3. While watching your computer's floppy and CD-ROM drive lights, select ODBC Datasources from the Files of Type box.

    Note that the floppy and CD-ROM drives are read repeatedly.

Additional query words: pra

Keywords: kbbug kbpending KB201268


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.