MartyConnelly
martyconnelly at shaw.ca
Wed Jul 18 14:15:37 CDT 2007
I believe you can bring up that wizard from VBA code but it has been 5 years since I last looked. Saw it done via VB6. jwcolby wrote: >That was it. And it comes with a little wizard for manually editing the >file. Cool. > > >John W. Colby >Colby Consulting >www.ColbyConsulting.com >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust >Sent: Wednesday, July 18, 2007 1:07 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] DSNs > >The path on XP is >Control Panel > Administrative Tools > Data Sources >(ODBC) > >Charlotte > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby >Sent: Wednesday, July 18, 2007 10:01 AM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] DSNs > > > >>Hopefully I'm not being condescending. >> >> > >Not at all. I don't know this stuff > > > >>Control Panel > Data Sources (ODBC) >> >> > >I don't have that. Windows XP Profession SP2 > > > >>HKLM\Software\ODBC\ODBC.INI >> >> > >I don't understand this one. Is this a directory path? A registry key? > >John W. Colby >Colby Consulting >www.ColbyConsulting.com >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bruce H. >Johnson >Sent: Wednesday, July 18, 2007 12:48 PM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] DSNs > >Hopefully I'm not being condescending. > >If this is for your machine only: > >Control Panel > Data Sources (ODBC) > >If you need it programmable: >HKLM\Software\ODBC\ODBC.INI > >HTH > > > -- Marty Connelly Victoria, B.C. Canada