Test linked table connectivity?

geralf

Registered User.
Local time
Today, 23:43
Joined
Nov 15, 2002
Messages
212
Hi,

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

Thanks in advance
 
Try and use them and catch the error on your error handling routine.
 
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
 
I believe *all* errors are trapable. I also believe you could recover without exiting the db.
 
If it helps, I just use the Dir() function to test if I can see the BackEnd before I relink everything again.
 
Thanks RG for your ideas. I'll check therm out tomorrow,
 
Always glad to help. Post back if you still have questions and/or issues.
 

Users who are viewing this thread

Back
Top Bottom