Brad Marks
BradM at blackforestltd.com
Thu Jun 28 13:44:34 CDT 2012
John, Lawrence, Jim, Thanks for the help with this issue. With your assistance, I was able to get things working last night. I really appreciate the advice and insights. Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Wednesday, June 27, 2012 6:12 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue You need to make sure you use the correct ODBC Admin program (one in %systemdrive%\Windows\SysWoW64 folder). Also make it a system DSN. See the following MSKB article: http://support.microsoft.com/kb/942976 Finially, if your trying to use 32 bit Access with other Office apps and they are 64 bit, that won't fly. Everything has to be one or the other. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, June 27, 2012 04:06 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue John, Thanks for the help. The new PC has Windows-7 (64 bit), but Access is 32 bit. It sounds like the 32 Bit ODBC Driver should work. When I try to set up ODBC and test the connection, the test fails. Really puzzled. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, June 27, 2012 1:50 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Windows-7 (64 Bit) ODBC Driver Issue > Do we need a 64-bit ODBC driver because we have Windows-7 (64 bit), even though we are running Access 2010 (32-bit). No, 64 bit drivers don't work with Office x32. It sounds like maybe the Access installed on that system is X64 and you are trying to use an X32 driver. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 6/27/2012 2:19 PM, Brad Marks wrote: > All, > > We have an Access 2010 (32 bit) application that uses ODBC to access > data in a Firebird database. > > This is currently working nicely on a number of PCs that are running > Windows XP or Windows-7 32 bit. > > Today, a new computer arrived which has Windows-7 64 bit. > The Firebird Database ODBC Driver that we have been using is 32 bit. We > cannot get it to work. > > I am confused. > > Do we need a 64-bit ODBC driver because we have Windows-7 (64 bit), even > though we are running Access 2010 (32-bit). > > Will a 64-bit ODBC driver work with Access 2010 (32 bit)? > > Thanks for your help, > > Brad > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.