Microsoft KB Archive/201268

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

Article ID: 201268

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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:  In Microsoft Windows, click Start, point to Settings, and then click Control Panel. Double-click ODBC Data Sources. Click the File DSN tab. 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. Click Set Directory, and then click OK.</ol>

<div class="status_section">

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

<div class="moreinformation_section">

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.