[dba-SQLServer]Access 2000 Adp Connection

You could, try checking if the connection status of the ADP is active, such
as currentproject.Connection.State = adStateOpen
then you could compare the connection string for what you want it to be.
something along the realm of

IF currentproject.connectionstring <> myConnString then
    currentproject.CloseConnection
    currentproject.OpenConnection myconnstring
end if


-Francisco
http://rcm.netfirms.com
----- Original Message -----
From: "Myke Myers" <mmmtbig at bellsouth.net>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, February 18, 2003 11:19 AM
Subject: [dba-SQLServer]Access 2000 Adp Connection


: I am responsible for enhancing a frontend Access 2000 Adp that is used
: in two locations by a corporate client.
:
: The server I use for development does NOT have the same name as either
: of the two production servers.
:
: Is there any way to build in an "auto detect" feature so it looks for a
: server name on start up and selects the appropriate server in the list
: of connections?
:
: TIA,
: Myke
: