Leroy,
Thanks for the response. So are you saying that there isn't a way for the connection in the project to update when the ODBC connection is updated...?
Jim
>>>Is there a way to have the connection within the project access the ODBC connection
>>>properties. So if the ODBC connection changes the connection in the project would update?
>
>What I would do is create a table (MyDSNs) with 2 fields in it, (THisMachine,DSNString).
>Store your StringConnect information in there.
>Keep that table on the network somewhere.
>
>In your main program that opens up your database do this:
>
>select myDsns
>LOCATE FOR ThisMAchine = SomeName
>myDSNString = DNSString
>
>** Now you can set the property of the database connection
>open Database myDatabase
>myConnection = 'My Connection Name in the Database'
>DBSETPROP(myConnection,"CONNECTION","CONNECTSTRING",myDSNString)
>
>
>
>
>This way you can have as many dsns as you want and just look for the DSN that you want.
>Hope this helps.
Thanks
Jim