Solved

DSN Less connection to linked sql server tables in access 2010

Posted on 2016-09-09
4
156 Views
Last Modified: 2016-09-12
It has been a long time since I have worked with Access

I think there was a way to link 2008 sql server tables without having to create an odbc dsn on each client machine but maybe not???
0
Comment
Question by:johnnyg123
[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
4 Comments
 
LVL 25

Expert Comment

by:SStory
ID: 41791375
Do these still work? They are for an older version.
https://support.microsoft.com/en-us/kb/892490

It uses VBA functions to create a tabledef.  Example of building the ODBC connection string inline (source: link above)

    '//Use trusted authentication if stUsername is not supplied.
        stConnect = "ODBC;DRIVER=SQL Server;SERVER=" & stServer & ";DATABASE=" & stDatabase & ";Trusted_Connection=Yes"
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 41792162
try
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

more:
http://www.connectionstrings.com/sql-server/

one more

How to create a DSN-less connection to SQL Server for linked tables in Access
https://support.microsoft.com/en-us/kb/892490
0
 
LVL 19

Accepted Solution

by:
Eric Sherman earned 500 total points
ID: 41792895
Review this post that I previously answered which is the same as your question.  It include the steps and  VBA code to create a DSNLess Connection.

https://www.experts-exchange.com/questions/28415368/Connect-Access-UI-to-SQL-DB.html#a40008254

ET
0
 

Author Closing Comment

by:johnnyg123
ID: 41794307
Thanks!
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

690 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