[AccessD] ODB connection

Thanks everone.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Thursday, February 28, 2013 9:26 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ODB connection

As an alternative, you could use a DSN-less connection with code:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

(That's a different Doug Steele, not me!)

Doug


On Thu, Feb 28, 2013 at 7:19 AM, Jim Dettman <jimdettman at verizon.net> wrote:

>
>  If your on a 64 bit OS, you need to use the ODBC applet in the sysWOW 
> folder.
>
>  The one in:
>
>  C:\Windows\System32\ODBCad32.EXE is a 64 bit version and any DSN 
> there won't be seen by 32 bit apps (which 2007 is).
>
>  This is the one the gets launched from control panel.
>
>  The one you need to use is:
>
>  C:\Windows\syswow64\ODBCad32.EXE, which is the 32 bit version.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, 
> Chester
> Sent: Thursday, February 28, 2013 10:06 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] ODB connection
>
> I have set up some ODBC connections through the control panel using 
> Windows 7. When I look for these connections in Access 2007 (external 
> data ODBC) I don't see them. Do I have to set them up in access also?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com