ConnectionString for Access 2010 database on a Win 7 Enterprise 32bit laptop

• cvrdevries

  Newbie

  Points: 3

  More actions

  October 27, 2014 at 10:20 am

  #99033

  Hello,

  I am trying to connect to an Access 2010 database on a Windows 7 Enterprise laptop.

  However, run-time error '3706' : 'Provider cannot be found.' appears.

  An Access 2010 database should use ACE.OLEDB.12.0,

  but because it's a 32bit system I should use Jet.OLEDB.4.0.

  I don't really know what to use in the connection string.

  Can somebody help me please?

  Thanks in advance.

  Regards,

  Tnatsnoc