ODBC for MS Access in XP 64 bit edition.

I tried out the trial version of XP 64 bit, and got things running modulo
the annoyances I might expect with a trial. But this one is a deal-breaker
for me, I'm afraid. I can install the 32 bit version of office with access,
and it works just fine, but it looks like it tries to install 32 bit ODBC
drivers which don't work, and the only ODBC driver that comes with the trial
download is for SQL Server. Is there currently a way to use ODBC to connect
to an access database in XP 64?

Charlie
Sun May 22 13:22:26 CDT 2005

Bob -- you're probably going to have better luck asking over in the Access
areas. I don't use access at all, so have no idea what the issues are.

--
Charlie.

Bob in Cupertino wrote:
> I tried out the trial version of XP 64 bit, and got things running
> modulo the annoyances I might expect with a trial. But this one is a
> deal-breaker for me, I'm afraid. I can install the 32 bit version of
> office with access, and it works just fine, but it looks like it
> tries to install 32 bit ODBC drivers which don't work, and the only
> ODBC driver that comes with the trial download is for SQL Server. Is
> there currently a way to use ODBC to connect to an access database in
> XP 64?

Andre
Sun May 22 14:07:21 CDT 2005

Timon B.
I started the ODBC DataSource Administrator loacatet in the directory
sysWOW64. This ODBC DataSource Administrator offers me also the Access ODBC
Driver for *.mdb and I was able to add the DataSource and access the
*.mdb-File via ODBC.

Think of the sysWOW64 as the System32 folder equivalent for 32-bit
applications. When Access 2003 was installed, it thinks it wrote to the
System32 folder but really wrote to sysWOW64. I'm not sure if the ODBC
Data Source Administrator supports the use of 32-bit drivers.

Rafael Rivera

Its also worth a try posting this query to the
microsoft.public.access.odbcclientsvr
newsgroup for more appropriate answers.
--

Andre
http://spaces.msn.com/members/adacosta
FAQ for MS AntiSpy http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm

"Bob in Cupertino" <BobinCupertino@discussions.microsoft.com> wrote in
message news:64415B1E-FB28-41B8-9DE8-8224BE06A46B@microsoft.com...
>I tried out the trial version of XP 64 bit, and got things running modulo
> the annoyances I might expect with a trial. But this one is a
> deal-breaker
> for me, I'm afraid. I can install the 32 bit version of office with
> access,
> and it works just fine, but it looks like it tries to install 32 bit ODBC
> drivers which don't work, and the only ODBC driver that comes with the
> trial
> download is for SQL Server. Is there currently a way to use ODBC to
> connect
> to an access database in XP 64?