> 5) One trick I learned is that Access does not refresh any ODBC properties
> except for the server name when you Refresh Linked Tables and Choose a
> different location. To change other settings you have to delete the linked
> table and relink it.
Hello, I know so You can use addin for Access, linked tables manager which
can refresh information about tables without delete links.
regards
Pavel Stehule