Connection Strings in Access

Hello,

I am developing an application in Access and need some help as to how to overcome a certain problem.

The program needs to have a remote connection to two seperate databases, each of which is found at a different IP address. The user selects their two databases from a list of about 5 or 6 and the program needs to create two seperate ODBC connections each time the program is ran.

The problem I am having is that I do not wish to have to manually set up the user DSN for each database instance every time the application is installed on a new machine. Is there a way of either:

1) Creating the DSN for each database instance the first time the program is ran or
2) Create the connection string so that it uses an IP address instead of the standard DSN.

Any help would be greatly apprectiated.

Andrew

Hello ,
Maybe you can write the database name ,server IP ,port No,UID and PWD into registry or ini file when finish setting up the program.Good luck.

Sam