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

Thanks bud. I never would have guessed it based on the name. "ACE"?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message news:eE72mf5zHHA.5948@xxxxxxxxxxxxxxxxxxxxxxx
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