Re: VBA - test link to tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 18:43:13 -0400

Ho Rob,

Only way to test connection is to execute some sort of *light* SQL statement
against linked table, which does not affect performance much and see if it
works or you get an error back. But it is not reliable way anyway. For
example if your connection is fine during testing but connection was dropped
in a middle of the operation, then you are in trouble. My suggestion is that
if you need to do something on multiple tables, then you could avoid this
issue if you execute all the statements inside of one transaction. If
something fails, then you could rollback the whole transaction on all the
tables 

-- 
Val Mazur
Microsoft MVP
"rob" <rwc1960@bellsouth.net> wrote in message 
news:ViXzc.43945$Kd5.41546@bignews4.bellsouth.net...
> Using an Access 2000 database and linked SQL tables...
>
> Before running a procedure which will replace data in the local Access db
> with data from SQL server, I would like to test that a "good" connection
> exists betweeen each SQL server table and the Access database.   (I do not
> want to replace the data if I cannot get  a "complete" set over.)
>
> Is there a preferred way to do this ?   Any code examples or books that
> cover the topic ?
>
> Thanks !
>
>
>

Relevant Pages