Linked Table Manager doesn't relink ODBC tables.

[lawsonium]

Hello,

The scenario. Two PC's, one older than the other, both running Windows 2000 (SP4) and Office 2000 (SP3). I use Access as a front end to a MySQL database, connections are made using ODBC.
I recently altered the structure of a table and attempted to re-link the table in access using the Linked Table Manager on the new PC. All that happened was the hourglass came on and never went away. I tried to do this on the old PC and it worked fine first time.

Any ideas why I can't get it to work on my new PC? It's quite important as I won't have the old PC with me much longer :-(

Regards,

Matt.

 

[Robert88]

Hi Matt,

Really testing my memory here. In control panel you will find a ODBC icon, within it you will have to create the same link that was previously created in order to connect the ODBC link that is required, but cannot find (your hourglass....).

Hope it helps.

Robert88

 

[lawsonium]

Hi Robert,

I discovered the answer to this was in my ODBC connections, thanks for your reply.

I removed all my old connections and remade them and all seems fine now.

Thanks,

Matt.

 

[Robert88]

Cool