Access SQL 32Bit with Win7 64

[YouWontSpamThisAdress]

Hi,

We have a local SQL database than we can query from Access 2003, however a
newly acquired computer With Windows and Office 2010, we can't access it
anymore.

The software company that created this software (non access), says it's
because Access is accessing through SQL with a 64bit driver.

Is there some way we could "force" access to run in 32bit mode.

[David W. Fenton]

"YouWontSpamThisAdress" <JustTryThi...@FuckinSpammers.com>
wrote in news:bpZ3o.378245$3k7....@en-nntp-13.dc1.easynews.com:

Did you install Office 2010 64-bit? If so, uninstall it and install
the 32-bit version, which is what MS recommends in the first place.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

[a a r o n . k e m p f @ g m a i l . c o m]

wow.. do you trust someone that doesn't know the slightest thing about
SQL?

I just don't trust Access newbies for a question like this. I would
go and ask someone in a SQL Server newsgroup.

I don't know what I'd do in your situation.. I've been -very- pro X64
for a long long long time.

I'd probably tell your vendor to explain more about the problem... it
seems like a very crappy answer.
Is the real problem that you're now using SQL 2005 / SQL 2008 instead
of SQL 2000 MSDE?

-Aaron

On Jul 29, 3:40 pm, "David W. Fenton" <NoEm...@SeeSignature.invalid>
wrote:
> "YouWontSpamThisAdress" <JustTryThisAdress...@FuckinSpammers.com>
> wrote innews:bpZ3o.378245$3k7....@en-nntp-13.dc1.easynews.com: