Question Locked

64-bit O/s and MS-Access MDB

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I bought a new computer with a 64-bit Windows Vista. All of my work is with MS-Access databases (mdb). The jet engine does not work on 64-bit platforms so I have no ODBC driver. Do I have to reload a 32-bit O/S or is there a way to make my database work without using SQL?

5 replies

by jdardard

Like so many others I too, have a 64 bit system with Windows 7 Ultimate OS. Also, like so many others, I cannot configure the MDAC platform to access my databases. I'm using Microsoft Office 2007. I understand that I can (possibly) resolve this issue by installing a 32 bit version of Windows 7 Ultimate on my machine. I haven't done so yet, but before I try that, I need to know if there's anything else I will need to do or consider to enable database access on my system. Any help will be greatly appreciated.

by oh smeg

Access Data File into SQL. That should work providing of course you have a copy of SQL on the computer.

I'm not sure what you are asking here do you want to use Access or do you want to be able to use your Data in a application better suited to a 64 Bit OS?

Col

by rharwick

I need to keep the data in Access format as it is distributed to many people using MS-Access and the Jet Engine ODBC driver.

by oh smeg

I would suggest removing the existing OS and replacing it with a 32 Bit Version and then using a version of Office prior to 2007.

While you may be able to use Office with the 64 Bit Version of Vista I'm not sure about the Jet Engine ODBC.

Well according to M$'s Knowledge Base the Problem is with Vista You can use the 64 Bit version by following the directions in this Knowledge Base Article 937284

http://tinyurl.com/6o5wpe

If you are using Office 2007 you need to ave any files in the MDB format as Office 2007 has introduced quite a few changes to the File Formats so the files produced with the new version of Office may not be readable on older versions of Office. Even if you do save in the old format the files may not be readable on older versions of Office.

Col

This discussion is closed to new replies.