Solved

How to find the corresponding ms sql link table?

Posted on 2008-10-20
3
292 Views
Last Modified: 2012-05-05
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
Comment
Question by:jaisonshereen
3 Comments
 
LVL 11

Expert Comment

by:Louis01
ID: 22764851
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
 
LVL 2

Accepted Solution

by:
valentpe earned 500 total points
ID: 22764858
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
 

Author Closing Comment

by:jaisonshereen
ID: 31508159
thanks dude!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now