Linked Tables and dependencies
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,