Hi,

I'm working with link tables that have a connection in the ODBC.
when I change the DB I want to work on, in the ODBC. I need to go to "Linked
Table Manager" and then select all the tables and choose
"Always prompt for new location" and choose the ODBC connection I did
before.
Is there an option to refresh the ODBC connection with the new DB without to
do this all the time ?

Thanks,

Lior.

See whether http://www.mvps.org/access/tables/tbl0010.htm at "The Access
Web" is what you're looking for.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Lior Montia" <(E-Mail Removed)> wrote in message
news:eudap0$njg$(E-Mail Removed)...
> Hi,
>
> I'm working with link tables that have a connection in the ODBC.
> when I change the DB I want to work on, in the ODBC. I need to go to
> "Linked Table Manager" and then select all the tables and choose
> "Always prompt for new location" and choose the ODBC connection I did
> before.
> Is there an option to refresh the ODBC connection with the new DB without
> to do this all the time ?
>
> Thanks,
>
> Lior.
>