Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ODBC connections from access 2003 to a SQL database

Posted on 2008-10-15
3
Medium Priority
?
271 Views
Last Modified: 2013-11-28
I am attempting to create an ODBC connection through Microsoft Access 2003 to a SQL database.  How do I create the connection?  I want to be able to build custom queries.  Thanks for your help.
0
Comment
Question by:jellyb30
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
dwe761 earned 500 total points
ID: 22722286
The simplest way is to link the tables to your Access database.  You won't get the best performance this way but you can try this first.
1) File |Get External Data | Link Tables...
2) Choose Files of Type:  ODBC Databases
3) Set up a File or Machine Data Source
4) Choose your Data Source and click OK
5) If it worked, you will be given a list of tables/views to which you may link
 
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question