How to resolve Linked Table Manager issue

[SachAccess]

Hi,
This issue is related to Linked Table Manager.
User is trying to ‘Relink’ on ‘Linked Table Manager’.
There are several tables to be linked. List can be seen in LTM view.
Few of the tables are reflecting as Failed in ‘Refresh Status’. Few are ‘Succeeded’.
Parent Data source is ODBC, I can see ‘Data Source Name’ mapped under ODBC.
What are the things that I should check and how can I resolve this, what steps I should follow to find root cause.
Can anyone please help me in this.

 

[arnelgp]

why do you need to everytime relink your db?
you need to create a Permanent IP for the backend.
you only do this Once.

 

[SachAccess]

Hi @arnelgp thanks for the help. Base tables are deleted and updated every month. May be that is the reason. Am not sure about the reason. Have a nice day ahead.

 

[arnelgp]

Base tables are deleted and updated every month.

can you just delete it's "content" (records)?
then the connection is still intact.

 

[SachAccess]

Hi @arnelgp thanks for the help. Sorry, I did not understand. Do you mean, I delete all the records from the table and re-try ?
Am not sure, if I will be allowed to it. Please give me some time to revert.

 

[arnelgp]

Base tables are deleted and updated every month

what do you mean by this? you can copy the content of the base table to another table (archive) and then delete all records of base table?
therefore you don't need to every time relink.

 

[SachAccess]

Hi @arnelgp thanks a lot for the help. Please give me some time to revert.

 

[Pat Hartman]

You should not leave the relinking to the user. I'm assuming that the table names don't change because that would be a real PITA to deal with. If that is the case, all you need to do is to "refresh" the links. In the opening form's startup code, try to run a query against one of the tables. If it fails, you know you need to call your refresh code. Otherwise, just open the menu as normal. I am not at my desk so I don't have code handy. You can find it by searching or perhaps someone will post their version.

 

[SachAccess]

Thanks a lot for the help. Have a nice day ahead.

You should not leave the relinking to the user. I'm assuming that the table names don't change because that would be a real PITA to deal with. If that is the case, all you need to do is to "refresh" the links. In the opening form's startup code, try to run a query against one of the tables. If it fails, you know you need to call your refresh code. Otherwise, just open the menu as normal. I am not at my desk so I don't have code handy. You can find it by searching or perhaps someone will post their version.

 

[Pat Hartman]

You too)

 

[SachAccess]

Hi everyone, thanks a lot for the help.
At present I do not have the actual file with me that is why am not able to respond to few of the suggestions mentioned above.
Will revert with details as soon as I get actual file.