Macro or VBA to Open ODBC Database Wizard

[Liz_I3]

Hi
Is it possible in Access 2010 to create a macro or vba to open the Get External Data ODBC Database wizard? In the same way as if you clicked on the ODBC Database button on the ribbon under External Data

Thanks
L

 

[james_lankford]

The tables should be a link to just refresh but our IT has set it up to replace tables daily....

don't understand the problem

if the tables are linked in access and the names of the source tables don't change then there should be any need to do this

the tables in the source database could be completed deleted and recreated
and as long as they are recreated with the same name access will still link to them

Edit: even if there are new names (why would IT do this??) you can still probably just update your connection information with the updated connection data using a simple script.