[AccessD] Updating Connect string for SQL Linked tables

Thanks, I'll take a look

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca]
Sent: Friday, November 04, 2005 1:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Updating Connect string for SQL Linked tables


Here is some code, to look at that does work. Tribble's BackEnd Relinker 
(alink21)
Available under menu  "useful files", you will have to register.
http://www.colbyconsulting.com/
look at the function fChangeLink
There is a lot of extraneous code to do with file dialog to get changed 
backend names.

rusty.hammond at cpiqpc.com wrote:

>I have a form (A97) that I designed to be able to change the parameters of
a
>connect string for any or all linked SQL tables in the current database
that
>the form resides in.  It seems to work once or twice on a database but then
>quits working.  By quits working, I mean it goes through the code, looks
>like it's working, but when you check the connect string (either through
the
>properties of the table, or looking at the msysobjects table), the connect
>string is still the old one and the changes are not reflected in the
>connection information on the SQL server.
>
>I'm posting the code used to update the connection strings.  Any ideas
would
>be greatly appreciated.

> <snip>


Rusty

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************