Table Linking

[PiedPiper70]

Having a senior momen here!

I've done re-linking tables in the past but this is slightly different. Can anyone point me to code to link an Access FE to an Access Back End WHERE I don't know how many tables there are or what they are called?

Any links gratefully followed!
Thanks

 

[CJ_London]

can't point you to code but you would have to do the following.

1. link to the MsysObjects table in the new back end
2. query the linked table to find all objects where type=1 and Flags=0 - these will be all the tables
3. loop through this list creating a linked table object

 

[namliam]

Instead of using Currentdb.Tabledefs, simply reference the other database....
See: http://msdn.microsoft.com/en-us/library/office/aa221178(v=office.11).aspx

 

[PiedPiper70]

Thanks all.

By the way, I'd just about cracked it when I stumbed across this:

http://www.access-programmers.co.uk/forums/showthread.php?t=191823