Solved Dependent tables

[AnilBagga]

I have a split DB and in the BE file I have a large number of tables.

Like Excel, can we find out where a table data is linked to - which form or query is using this data of the table. I have a linked Excel file which I used in some forms and need to switch this linkage to a table

 

[theDBguy]

Yes, but you would do that in the FE, because the BE would have no idea what's using it.

So, in the FE, try using the Dependency Checker by selecting your linked Excel table and then clicking on the Object Dependencies button on the Database Tools Ribbon Tab.

Hope that helps...

 

[Isaac]

my favorite technique (this is just me, i find it fun) is to hit alt+f11 (opens vba project), then View > Immediate window (do it once and it will stick always), then type ?currentdb.tabledefs("nameoftable").connect and hit enter

 

[AnilBagga]

Yes, but you would do that in the FE, because the BE would have no idea what's using it.

So, in the FE, try using the Dependency Checker by selecting your linked Excel table and then clicking on the Object Dependencies button on the Database Tools Ribbon Tab.

Hope that helps...

Thanks. That was what I needed

 

[AnilBagga]

my favorite technique (this is just me, i find it fun) is to hit alt+f11 (opens vba project), then View > Immediate window (do it once and it will stick always), then type ?currentdb.tabledefs("nameoftable").connect and hit enter

I use a Mac and work on the server which is Windows and has Access (mac does not have Access). AltF11 throws up something else unfortunately. Will try it later with a windows machine. Thanks for the input

 

[Isaac]

I use a Mac and work on the server which is Windows and has Access (mac does not have Access). AltF11 throws up something else unfortunately. Will try it later with a windows machine. Thanks for the input

Ahh yes, the joys of special key combo's vs. remote desktop

 

[theDBguy]

Thanks. That was what I needed

Hi. Glad we could assist. Good luck with your project.