Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Selecting ODBC Source

I would like to write a program to let use to select the Data Source from ODBC make use of the ODBC Dialog (the same case as Import Data from ODBC Database using Access). How can I do that? how to popup the ODBC window and return the user's selection?
0
LCP
Asked:
LCP
1 Solution
 
manchulaCommented:
If you did not give any data source name, automatically the ODBC Select Data Source Window will get displayed, and the selected DSN will get connected.

    Dim db As Database
    Set db = OpenDatabase("")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now