Solved

Connecting MS SQL and MS Access

Posted on 2014-12-07
2
67 Views
Last Modified: 2014-12-13
How do you connect MS Access(2013) to a MS SQL Server Database (2008)?
0
Comment
Question by:Benki Canoso
2 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 40485750
Two basic options
1.  Create a dsn that points to the sql server database, and connect (you'll need the appropriate authentication details)
2.  Create a dsn-less connection - much the same as 1. above, but done through code.

For a new comer to this option 1 is probably the best. In Access, chose the external data, and select ODBC connection. This will start the wizard - just follow your nose.


Kelvin
0
 
LVL 10

Accepted Solution

by:
10023 earned 500 total points
ID: 40485752
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Viewers will learn how the fundamental information of how to create a table.

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now