Controlling IBM DB2 from Access
A number of our databases connect to remote data sources via ODBC. These connections are configured using the IBM DB2 application. A recurring problem I have is that the department building the laptops for our staff often fail to do the configuring correctly, resulting in my needing to do it manually later. As with all tasks that get repeated, I'm trying to automate this.
I've gotten as far as using VBA to check if they have this application installed and, if so, to open the Configuration Assistant window, ready to import a working profile.
Now I'm trying to work out how to
1. Select the 'Configure' menu, choose 'Import Profile', then choose 'All'
2. In the displayed window, navigate to where I have a profile saved and select that file
3. Click on 'Open' to import it.
Any pointers gratefully received.