I have an ADP created with forms and VB code. It is currently working and connected to a development SQL Server database.
The project is now moving into "Testing" phase, so we are changing to the test SQL Server database, which is on a different server and has a different database name.
I can't figure out how to get to the Data Link Properties screen where I originally set the data source information.
Is there a easy way to change a property of my existing ADP file to point to the new data source? Or, do I have to create a new ADP and import in all my code and forms?
Thanks for your help.
The project is now moving into "Testing" phase, so we are changing to the test SQL Server database, which is on a different server and has a different database name.
I can't figure out how to get to the Data Link Properties screen where I originally set the data source information.
Is there a easy way to change a property of my existing ADP file to point to the new data source? Or, do I have to create a new ADP and import in all my code and forms?
Thanks for your help.