P
Phil Smith
I have several databases which link to a MYSQL server.
Some of them have a dozen linked tables, some of them have 150 linked
tables. Most if not all of the tables link to the same database.
When I run the Linked Table Manager, to point the entire database from
my live production database to a day old backup database, I do so by
launching the Linked Table Manager, checking Always prompt for new
locaton, Select All, and OK.
Most of time, I will get a dialog box to choose my ODBC connection, a
little green progress bar, slowly filling up, and after some period of
time, (typically under one minute) it's all done. All of my tables have
been updated, the world is a wonderful place.
OTHER TIMES, however, I will get a dialog box to choose my ODBC
connection, hit OK, one table will get updated then back to the dialog
box to choose my odbc connector, one more table will be updated, lather
rinse repeat for every table in the database.
192 tables is my largest database, and I am sick and tired of having to
choose my odbc connection 192 times. Why doesn't it run them all at
once, like the others?
More importantly, how can I make it run them all at once, just like the
others?
Some of them have a dozen linked tables, some of them have 150 linked
tables. Most if not all of the tables link to the same database.
When I run the Linked Table Manager, to point the entire database from
my live production database to a day old backup database, I do so by
launching the Linked Table Manager, checking Always prompt for new
locaton, Select All, and OK.
Most of time, I will get a dialog box to choose my ODBC connection, a
little green progress bar, slowly filling up, and after some period of
time, (typically under one minute) it's all done. All of my tables have
been updated, the world is a wonderful place.
OTHER TIMES, however, I will get a dialog box to choose my ODBC
connection, hit OK, one table will get updated then back to the dialog
box to choose my odbc connector, one more table will be updated, lather
rinse repeat for every table in the database.
192 tables is my largest database, and I am sick and tired of having to
choose my odbc connection 192 times. Why doesn't it run them all at
once, like the others?
More importantly, how can I make it run them all at once, just like the
others?