Solved

DSN Less connection to linked sql server tables in access 2010

Posted on 2016-09-09
4
88 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
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 42

Expert Comment

by:EugeneZ
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

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…

813 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

19 Experts available now in Live!

Get 1:1 Help Now