ODBC connection string

[JamesDeckert]

I link to another company's table via an ODBC connection which the other
company sets up on install of their software. I've a company in the UK using
my software, and I find out that the connection string used is named
different in the UK. The table I'm linking to is a DBase or some other file
format (not SQL Server). It is a System DSN which has a login password which
I don't know (and am not sure if the other company would give me).

I can think of a couple of ways of handling this. Is one better than the
other? Is there a better way?

1. Create a separate linked table using the second ODBC name. Then use
whichever table (in a query) based on the settings in my program for which
country the software is in.

2. Change the connection string for the linked table. The string is
contained in the MSysObjects table, Connect field. Could I just change this
field to the correct connection string using an update query? I think this is
a read only table.

I'd prefer option 2 as it seems cleaner to me, but I don't know the best way
to approach this.

thanks,
James