Solved

Connecting MS SQL and MS Access

Posted on 2014-12-07
2
74 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
[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
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

734 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