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

ID: Q201268

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and 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 this to be a problem in the Microsoft products 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          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 13, 1999