[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Connecting MS SQL and MS Access

Posted on 2014-12-07
2
Medium Priority
?
97 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 2000 total points
ID: 40485752
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

591 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