Test linked table connectivity?

[geralf]

Hi,

Is it possible to check using VBA, if the connection for linked tables are OK?

Thanks in advance

 

[RuralGuy]

Try and use them and catch the error on your error handling routine.

 

[geralf]

Is the 'disk error or netwok error' a trapable error? I'm not at work now, so I can't test it now.

If it is trapable, would it then be possible to re-connect using VBA without closing the database application and restart again?

Thanks for your reply RuralGuy

 

[RuralGuy]

I believe *all* errors are trapable. I also believe you could recover without exiting the db.

 

[RuralGuy]

If it helps, I just use the Dir() function to test if I can see the BackEnd before I relink everything again.

 

[geralf]

Thanks RG for your ideas. I'll check therm out tomorrow,

 

[RuralGuy]

Always glad to help. Post back if you still have questions and/or issues.