[AccessD] OT - Changing a DSN Connection

Paul,

<<I could write in Access or VB that a a click of a button will find these
DSN's and replace the server name ?>>

  I've got a VB6 program to update DSN's based on an access table that I'd
be willing to share.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Hartland
(ISHARP)
Sent: Thursday, January 05, 2006 8:21 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] OT - Changing a DSN Connection


To all,

We are having a new server (very soon) and changing the name to something
like AL-MASTER from AL-ORR the thing is I have a lot of Excel management
reports which use various DSN's pointing to AL-ORR, is there something I
could write in Access or VB that a a click of a button will find these DSN's
and replace the server name ?

Any help on this would be greatly appreciated.

Thanks in advance

Paul Hartland

P.S. Happy New Year to all list members, don't know what I would do without
it sometimes

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com