Getting Access 2007 "Invalid Provider" on Windows Vista 64-bit

[Thatch]

Hi All,

I have a piece of software that uses an Access 2007 database. I use the
provide:

"Provider=Microsoft.ACE.OLEDB.12.0"

It works great with the Access 2007 Runtime installed on any 32-bit machine.
However, on Windows Vista 64-bit, I get a "Invalid Provider" error or
"Provider does not exist" error. Does anyone know what is the Access 2007
Runtime provider on Vista 64-bit?

Also, how does one find the database providers on a system?

Thanx in advance.

T

 

[Tom van Stiphout]

On Fri, 21 Nov 2008 16:04:00 -0800, Thatch

To answer your last question I sometimes create a new empty file and
rename it "test.udl"
Then double-click the file and go to the first tab. That's the
providers.

-Tom.
Microsoft Access MVP

 

[Douglas J. Steele]

As far as I know, there isn't a 64-bit provider. I believe there's was a
way to use 32-bit providers when running on 64-bit operating systems, but
I'm afraid I don't know what it is, as I haven't had to work with 64-bit OS
yet.

 

[Thatch]

There must be one. So how does one access an Access 2007 database on Windows
64-bit OS? Access 2007 works in that environment so it must be using some
sort of access to the database. So how does one get into it?

Tom

 

[Thatch]

Thanx. I'll try that.

T

On Fri, 21 Nov 2008 16:04:00 -0800, Thatch

To answer your last question I sometimes create a new empty file and
rename it "test.udl"
Then double-click the file and go to the first tab. That's the
providers.

-Tom.
Microsoft Access MVP

 

[Douglas J. Steele]

By going through the 32 bit emulation (or whatever it's called)