Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105512

From BetaArchive Wiki
Knowledge Base


ACC: Data Source Dialog Box Does Not List ODBC Data Sources

Article ID: 105512

Article Last Modified on 5/6/2003



APPLIES TO

  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition



This article was previously published under Q105512

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

SUMMARY

When you are attempting to attach or import a table that is accessible through ODBC (such as a SQL Server, Sybase SQL Server, or ORACLE table), the Data Source dialog box does not list the table as a choice.

In order to make working with ODBC data sources as transparent as possible, there is no explicit choice for each source in the Data Source dialog box.

To select an ODBC data source, select SQL Database in the Data Source dialog box. Another dialog box will appear displaying a list of servers with available ODBC data sources.

Keywords: kbinfo kbinterop KB105512