Windows 7 ODBC tables

[excelhack]

I recently had Windows 7 installed on my machine. The Access databases I use require an ODBC connection. The problem is that Windows 7 operates on a 64 bit system and Access operates on a 32 bit system. I've seen a number of drivers available to use as a bridge between the two, but I'm not sure which one would be right for my application. Has anyone out there experienced this as well? I use Access heavily in my job and I'm ready to go back to XP.

 

[xenou]

Hi, it's hard to see specifically what the problem is. You should have no problem opening and using an Access database with Windows 7 (it doesn't matter if it is a 32 bit version - Windows will run it as a 32 bit program). There is no need to use ODBC for this. What exactly are you trying to do?
ξ

 

[excelhack]

I agree that Windows 7 should be downward compatible. Longer than i've been here, the ODBC connection has been used for Access to link to our AS tables.

 

[xenou]

Okay, what are AS tables?

 

[excelhack]

AS tables are the tables within our JDE accounting system.

 

[xenou]

Not sure who that is but probably they would be the ones to provide you with the drivers you need or point you in the right direction (i.e., check out their website, support pages, or call their support number).

 

[Kreszch68]

If it is AS as in AS/400, take a look at this site for your ODBC connection string

AS/400 (IBM iSeries) Connection String Samples - ConnectionStrings.com

 

[gdesreu]

I recently had Windows 7 installed on my machine. The Access databases I use require an ODBC connection. The problem is that Windows 7 operates on a 64 bit system and Access operates on a 32 bit system. I've seen a number of drivers available to use as a bridge between the two, but I'm not sure which one would be right for my application. Has anyone out there experienced this as well? I use Access heavily in my job and I'm ready to go back to XP.

If you are doing what I think you are doing, yes I have run into the same issue. The Machine data sources are different for 32 bit vs. 64. Run this command to set the connection up if you are using 64bit windows. The one from the control panel wont work (at least it didnt for me)
%windir%\SysWOW64\odbcad32.exe

%SystemRoot%\system32\odbcad32.exe is used to create and maintain data source names for 64-bit applications.

%SystemRoot%\SysWOW64\odbcad32.exe is used to create and maintain data source names for 32-bit applications, including 32-bit applications that run on 64-bit operating systems.

 

[excelhack]

Thanks Kreszch68. Yes, that's right. They are AS/400 tables. I read the article. It looks like if I can get my hands on a copy of Office 2010, I might be able to use my databases once again. I'll contact my IT department and let you know how I make out. Our IT department only helps electrons move quickly, but their pace is more closely related to that of a snail.

 

[excelhack]

%SystemRoot%\system32\odbcad32.exe is used to create and maintain data source names for 64-bit applications.

%SystemRoot%\SysWOW64\odbcad32.exe is used to create and maintain data source names for 32-bit applications, including 32-bit applications that run on 64-bit operating systems.[/QUOTE]

Thanks for this. I knew I wasn't alone. I've seen a mention or two of WOW64 before. I'll pass this along to my IT Dept as well.