Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?

William Vaughn wrote:
Bob, I just converted one of my NWind.mdb databases using Access 2007
and it created an entirely new database file with a new extension. Now the
JET 4.0 OLE DB provider won't open it. What are customers supposed to do
now?
Fall back 10 yards and punt?


There's a new provider for the Jet2007 databases. I don't remember what it's
called. Off to connectionstrings.com ...
Here we go:
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages