I am using the following as connecting string to connect to Acess 2010 databse.
This is working fine in systems with windows 2007 and excel 2007, but fails when it is windows XP with excel 2003.
"Provider=Microsoft.ACE.OLEDB.12.0; Data source=\\fileserver\Departments\BI_Manuals\MDB\dbODMIS.accdb;
"Persist Security Info=False"
Any suggestion will be appreciated?
I guess that it is 64 bit vs 32 bit issue. but i am unable to get around the problem.