You can enter and save connections to multiple databases. 1 connection can be set as default so the application connects to that database automatically when launced. Connection data can be exported and imported.
When updating or inserting new connections, first save the records from the form, then save the application by pressing the icon in the upper left corner of Excel. You will then be asked to enter a name for the application. The next time you launch the application the connection details are available.