I am trying to install a VB.net application which uses an Access 2007 database with the connection string including 'Microsoft ACE.OLEDB. 12.0' for the ACCDB file format, and it works fine on a normal Windows 7 machine, but when I install on an older XP machine which does not have Office 2007, I get the following message when I start my program:
Unhandled exception has occurred in your application. If you click
Continue, the application will ignore this error and attempt to continue. If
you click Quit, the application will close immediately.
The 'Microsoft ACE.OLEDB.12.0' provider is not registered on the local
machine.
So my question is, is there a way that when I build my deployment to include perhaps an Access 2007 runtime or merge module so that I don't have to keep installing that separately when I do a network installation on client PCs?
