• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

DSN Less connection to linked sql server tables in access 2010

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
johnnyg123
Asked:
johnnyg123
1 Solution
 
SStoryCommented:
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
 
Eugene ZCommented:
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
 
Eric ShermanAccountant/DeveloperCommented:
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
 
johnnyg123Author Commented:
Thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now