I have linked tables in a sql database in my Access database. I need to build a function that will accept the name of a linked table, and return the name of the server on which the table resides.
I already know how to query MSysObjects to get the .Connect string, which tells me the name of the DSN used for the linking
((SELECT *FROM MSysObjects WHERE (((Type)=4)) OR (((Type)=6))
or Dlookup("Connect", "MSysObjects", "Name = 'mstLookupTb'")
). I don't need the name of the DSN; I need the name of the server. In this screenshot, I need to get "Sandbox01", not "PaulsSandbox".