>>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
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.
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson