Recent content by flipflaps

Thanks to all for the suggestions and I have now got it working using the following code so that I can call it when required and make sure a positive result is returned at the end of the process. Public Function ODBCmapping(dbname As String) As Boolean On Error GoTo err_ODBCmapping...

Hi VincilLabs, The DB names will always be the same. The table and field names will remain identical between the Live & Test systems. Data I am not worried about in the Test DB - the overnight script basically just makes a complete copy of the Live DB (It is backed up separately also) so...

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...