Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ODBC connections from access 2003 to a SQL database

Posted on 2008-10-15
3
Medium Priority
?
275 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
1 Comment
 
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

773 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