Thursday, April 10, 2008

With ADO.net 3.5 you no longer need to use/install the Jet driver for working with an Access database.

You can use this connection string(reads Access 2007 and below).

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

Thanks to ADO.NET 3.5 Cookbook, 2nd Edition(if I were smarter I would have used my amazon correspondent link)

And ConnectionStrings.com

posted by Aaron Fischer on Thursday, April 10, 2008 12:45:44 PM (Pacific Standard Time, UTC-08:00)   #    Comments [0]