how does access connect to SQL

• snomadj

  SSCarpal Tunnel

  Points: 4491

  More actions

  January 12, 2016 at 8:12 am

  #74444

  I don't know access but I have an access db that somehow interfaces with an old SQL database I need to move.

  So I need to figure out how the access db connects to SQL in order to be able to move the db & change the connection. I've clicked around the access db in question for hours but can't find where an odbc or connect string is stored. Any pointers gratefully accepted!!

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  January 12, 2016 at 11:10 am

  #1851370

  snomadj (1/12/2016)

  ---

  I don't know access but I have an access db that somehow interfaces with an old SQL database I need to move.

  So I need to figure out how the access db connects to SQL in order to be able to move the db & change the connection. I've clicked around the access db in question for hours but can't find where an odbc or connect string is stored. Any pointers gratefully accepted!!

  Which version of Access and SQL Server? Normally this would be an ODBC connection

  

• Alexander Suprun

  SSCertifiable

  Points: 6253

  More actions

  January 12, 2016 at 3:10 pm

  #1851436

  Try "External Data -> Linked Table Manager".

  ---

  Alex Suprun

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  January 12, 2016 at 10:39 pm

  #1851486

  Check out the following link may be this will help you to out: http://www.brighthub.com/computing/windows-platform/articles/25996.aspx

• snomadj

  SSCarpal Tunnel

  Points: 4491

  More actions

  January 13, 2016 at 4:53 am

  #1851531

  Thanks all, appreciate your replies!

  I was quite lost. I could see incoming calls to SQL from host A supposedly via the access db. However, having spent hours on it, I found an additional mde file that had linked tables connecting via a dsn.

  I'm hoping I only need to amend the dsn. I will find out!

  Thank you all.