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

  • Thread starter Thread starter Thatch
  • Start date Start date
T

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
 
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
 
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.
 
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
 
Thanx. I'll try that.

T

Tom van Stiphout said:
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
Click to expand...
 
Back
Top