Where is the Linked Tables' system data stored...?

[polaris]

Hello all... I have an MS Access app with hundreds of linked tables, spread among 3 different .MDB files. Long story, but every year, I have to re-link all tables to different .MDB files for the given year. The re-linking process is time consuming (I have to visually check every table in the Linked Table Manager and assign it to the correct .MDB file). I wonder if there is any hidden MS Access "system table" which has the linked tables information, and which I could use to automate this yearly re-linking process...? I reckon that this linked table information has to be stored SOMEWHERE in the .MDB file... But where...? Any info or suggestion is greatly appreciated!!

-Paul

 

[MarkK]

Yeah, check out MSysObjects.
Actually, here's a query you can use...

SELECT * FROM MSysObjects

Paste that into the query designer SQL view and save it. Or you can show hidden objects and show system objects, but then you have all the other system tables cluttering up your 'tables' view.
Happy holidays,
Mark

 

[polaris]

Great, so simple...! Thank you Mark (and apologies for the late reply, I was away on holidays...) Have a great 2012!

Paul