>>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 && This could be a variable, property or Method that returns the name that you need
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.