Hi,
Is there any way to set the data source dynamically by using a form with a drop down list (so that a business person could do it)
We have Development, Test, and Production databases. User names and passwords are different for each. I would like to set up the Access front end so that it automatically connects to the Production DB, but you could switch it to the Development or Test Database if you have a valid username and password.
Thx,
Jayme
Is there any way to set the data source dynamically by using a form with a drop down list (so that a business person could do it)
We have Development, Test, and Production databases. User names and passwords are different for each. I would like to set up the Access front end so that it automatically connects to the Production DB, but you could switch it to the Development or Test Database if you have a valid username and password.
Thx,
Jayme
