Hi folks,
I have a database that goes to a client for evaluation/purchase as an
Access2k2FE / Access2k2 BE. When they decide to upsize to MySQL or SQL
Server, I would like an easy way to allow them to switch table
sources.
When I try to use Linked Table Manager, and the Find a File dialog
pops up, it only gives me the option to look for .mdb or *.*. I would
have thought it could allow me to choose an ODBC data source, but it
doesnt appear to do so.
So instead I can use File / Get External Data / Link tables, except
the obvious drawback is that it's a complicated manual process, and I
don't want clients to have to do this.
I can code the RefreshLinks sample to do it all (I have versions that
do Access refreshes or SQLServer refreshes, with the ODBC string and
all), but will it allow me to use and swap the same TableDef connect
string for either the Access version of the table or the 'upsized'
SQLServer version of the same table?
As usual, about this time in the resolution of the problem I think
that lot's of colleagues must have been down this road already - so
any suggestions or alternative solutions would be much appreciated.
Ray