Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-22-2019, 06:41 AM   #1
Alc
Newly Registered User
 
Join Date: Mar 2007
Location: Ontario
Posts: 2,308
Thanks: 48
Thanked 28 Times in 27 Posts
Alc will become famous soon enough Alc will become famous soon enough
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.

Alc is offline   Reply With Quote
Old 01-22-2019, 07:35 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,370
Thanks: 0
Thanked 743 Times in 728 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Controlling IBM DB2 from Access

the connnections are actually on the PC under ODBC connections in the PC control panel.
Ranman256 is offline   Reply With Quote
Old 01-22-2019, 08:31 AM   #3
Alc
Newly Registered User
 
Join Date: Mar 2007
Location: Ontario
Posts: 2,308
Thanks: 48
Thanked 28 Times in 27 Posts
Alc will become famous soon enough Alc will become famous soon enough
Re: Controlling IBM DB2 from Access

Thanks for the response.
I wouldn't know where to set them from there. I was hoping to duplicate the steps I'd use for a manual configuration.

Alc is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Controlling MS Excel from MS Access using VBA mims Modules & VBA 3 07-31-2011 06:09 PM
Controlling Excel from within Access maGemme Modules & VBA 12 07-14-2010 02:52 PM
Controlling Excel From Access DevastatioN Modules & VBA 10 05-30-2008 07:08 AM
Controlling Word from Access odin1701 Modules & VBA 0 05-06-2008 05:50 AM
Controlling another application from within Access Sprocket Modules & VBA 10 06-20-2006 05:10 AM




All times are GMT -8. The time now is 11:45 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World