Hi,
first timer in the forum, so be gentle!
I have an Access2007 front end connected to SQL Server 2008 with several linked tables. On the server there is the live DB (LLOM) and every night the server creates a duplicate DB (LLOM_TEST) for testing purposes.
I can of course manually re-link...