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

How to find the corresponding ms sql link table?

i have a link table in ms access which connect to ms sql ...how to find out which ms sql table this access link table connect to?
0
jaisonshereen
Asked:
jaisonshereen
1 Solution
 
Louis01Commented:
Maybe the stored procedure sp_tables_ex can give you what you need?
See http://msdn.microsoft.com/en-us/library/aa260332(SQL.80).aspx
0
 
valentpeCommented:
Place Your mouse cursor over table name. Wait until hint appears. Connect string should appear - name of connected table folows after string "TABLE=".

Cheers PV
0
 
jaisonshereenAuthor Commented:
thanks dude!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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