The Jet.Oledb.4.0 driver doesn't work for access 2007 (.accdb), only for Access 2003 (*.mdb) and below.
So either convert your .accdb file to an .mdb, or use the new ACE 12.0 driver. Note that this driver is NOT installed by default on a Windows server, so it might not be available in you production environment!
hans_v
All-Star
35986 Points
6550 Posts
Re: Database connection help, retreive email addresses from database, no connection.
May 01, 2012 12:34 PM|LINK
The Jet.Oledb.4.0 driver doesn't work for access 2007 (.accdb), only for Access 2003 (*.mdb) and below.
So either convert your .accdb file to an .mdb, or use the new ACE 12.0 driver. Note that this driver is NOT installed by default on a Windows server, so it might not be available in you production environment!
http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET