Solved

ODBC connections from access 2003 to a SQL database

Posted on 2008-10-15
3
255 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
3 Comments
 
LVL 10

Accepted Solution

by:
dwe761 earned 125 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 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