Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-02-2009, 03:07 PM   #1
dirkpitt
Registered User
 
Join Date: Nov 2009
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
dirkpitt is on a distinguished road
Linked Tables and dependencies

Hi Guys,

I searched with my best friend Google on the entire web and could not find any correct answer to my question:

why MS Access 2007 does not allow to get object dependencies for Linked Tables.

Here is my pb:
I have a db that have more or less 100 linked tables and more or less 200 queries.
I did not build this db. The guy that did left the company.

I inheritate of this and need to undertsand how this db works in order to put some securities on this db.

I can see dependencies of native access tables but nothing concerning all the linked tables.

If I open the design view of queries, I can see that they use some linked tables. There is 200+ queries. So defining which linked table is used where is a nightmare.

Do you have any idea on how to see those dependencies ?

Thank you in advance,

Dirkpitt

dirkpitt is offline   Reply With Quote
Old 11-02-2009, 08:33 PM   #2
ezfriend
Newly Registered User
 
ezfriend's Avatar
 
Join Date: Nov 2006
Posts: 242
Thanks: 0
Thanked 0 Times in 0 Posts
ezfriend is on a distinguished road
Re: Linked Tables and dependencies

You can write a quick code to return all of the query definition into a text file or something and then from there, you can tell which tables/linked tables are used in the query.

More information: http://articles.techrepublic.com.com...1-5047664.html
__________________
The answer you are looking for is only a click away
ezfriend is offline   Reply With Quote
Old 11-04-2009, 03:25 PM   #3
dirkpitt
Registered User
 
Join Date: Nov 2009
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
dirkpitt is on a distinguished road
Re: Linked Tables and dependencies

thank you for your help

I'll look at it deeper. Seems that it will help.

Dirk

dirkpitt is offline   Reply With Quote
Old 01-31-2013, 11:46 AM   #4
Avon4026
Newly Registered User
 
Join Date: Jan 2013
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Avon4026 is on a distinguished road
Re: Linked Tables and dependencies

I just upgraded from Access 2003 to 2007. And indeed it appears as if you cant get object dependencies on ODBC linked tables. On a local table the Database Tools option "Object Dependencies" is available, but it greys out and is not available on a linked table. I could find nothing on this "feature" or how to overcome it. So I started playing around and found a work around (annoying as that is). So here it is:
1) click on a local table and then click on "Object Dependencies" under Database Tools. This will bring up the Object Dependencies pane.
2) Scroll in your list of tables to the linked table you want dependencies on and click on it.
3) In the Object Dependencies pane - click the refresh link. You should now see your linked table as the named table in the pane and any dependencies you are looking for.

Hoakey I know- but it works.

Avon4026 is offline   Reply With Quote
The Following User Says Thank You to Avon4026 For This Useful Post:
SQLWayne (04-14-2016)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007, Object Dependencies - Error KathyL General 0 07-02-2009 03:30 PM
Hierarchical list of table dependencies QueenKirsty Tables 2 05-01-2009 04:32 AM
HELP! Reports & Object Dependencies cashr23523 Reports 1 08-21-2008 08:32 AM
Drop down menus with dependencies.. asmodius General 2 10-22-2003 10:26 AM




All times are GMT -8. The time now is 04:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World