Unanswered: Change connection of Access Data Project
Got an ADP interface to SQL Server that I'm working on. I can change the connection uses the Access menu system, but I want to create a form that allows the user to enter a Server Name, Database Name, Login, and Password, and then changes the existing connection.
I just CANNOT find this in the Access or VB help systems (which seem to get less helpful with every new feature that is added to them...).
Anybody done this before?
If it's not practically useful, then it's practically useless.