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]
Name
E-mail
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):

Live Comment Preview