1

There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this?

The linked table manager appears to point to something but doesn't give details of any underlying db as such

Anywhere else I should check?

EDIT: Not quite sure why this has been flagged for closure due to not enough information. The Microsoft Access 2010 is consuming a SQL Server database. It is not immediately apparent which database it is in fact consuming, ergo, how can I find this out

7
  • 1
    What are you talking about, dude? What do you try to do, what language, why do you ask here and not at SO? Jan 8, 2016 at 9:13
  • Because it's not programming. How is determining which db I am pointing at programming? What do you mean "what language". English, do you speak it? Jan 8, 2016 at 9:19
  • 1
    I mean programming language, what else? Jan 8, 2016 at 9:21
  • 1
    Give us please a fair chance to help you, adolf, and provide finally more infos! Jan 8, 2016 at 9:27
  • 1
    Told you it wasn't programming related :D Jan 8, 2016 at 13:11

1 Answer 1

1

Open Access

Hit F11 to show the side bar
expand tables, go to any linked table
hover over the table and it will show the connection string value in the tooltip

OR

right click on the sidebar and under "navigation options" select "show hidden objects"
then under 'tables' go to MSysObjects and take a look at the values held in the 'connect' column

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .