Solved

How to find the corresponding ms sql link table?

Posted on 2008-10-20
3
291 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
Comment Utility
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
Comment Utility
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
Comment Utility
thanks dude!
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 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

10 Experts available now in Live!

Get 1:1 Help Now