Linked tables - test connections

  • Thread starter Thread starter rob
  • Start date Start date
R

rob

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 !
 
Hi Rob,

Why not just use the "RefreshLink Method". See the Microsoft Access VBA
help topic "RefreshLink Method Example"


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Reply-To: "rob" <[email protected]>
| From: "rob" <[email protected]>
| Newsgroups: microsoft.public.access.formscoding
| Subject: Linked tables - test connections
| Lines: 15
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <[email protected]>
| X-Complaints-To: (e-mail address removed)
| X-Abuse-Info: Please forward a copy of all headers for proper handling
| X-Trace:
ogjnolidcdijhjikdbdpiflmbcekedmfhojhikkbagflhcbonknmpocnacglbhdnhllcamobfape
piohaamemakjdbmoindjbpeclalcloiihiplmnalmffcadaeghdbojpcdcjpebepmkhfnfjidifk
lkedecdl
| NNTP-Posting-Date: Tue, 15 Jun 2004 08:42:02 EDT
| Organization: BellSouth Internet Group
| Date: Tue, 15 Jun 2004 09:32:24 -0400
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca.gi
ganews.com!nntp.giganews.com!news.glorb.com!bigfeed.bellsouth.net!bignumb.be
llsouth.net!news.bellsouth.net!bignews2.bellsouth.net.POSTED!9710feea!not-fo
r-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.formscoding:235893
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| 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 !
|
|
|
|
|
 
Thanks Eric,

A few people who do not know much about Access are going to be using the
program... Basically, if they are hooked up to the server, they have the
option of dumping all the data in the local Access tables and getting fresh
data from the server.... I do not want to wipe out all the old data if they
are unable to get a good connection to the server... the program will be on
their laptop...
 
Back
Top