problem with Access 2013 in vb app in release mode

[jassie]

I changed a VB desktop application so be a VB.Net 2010 desktop application to use an Access 2013 database so users would not be using workstations that use Windows 95 as the operating system.
To accomplish this goal, I did the following:


1. I downloaded 2007 Office System Driver: Data Connectivity Components from the following url:
http://www.microsoft.com/en-us/downl....aspx?id=23734.
2. I built the application in debug mode and installed the application on a Windows 7 laptop and everything ran successfully.
3. However if I compile the application in 'release' mode, I get an error message that basically says
' it does not recognize the Provider=Microsoft.ACE.OLEDB.15.0' provider.
It is better to deploy a desktop application in Release mode instead of Debug mode. However the 'Release mode' install does not work.
Thus would you tell me what I should possibly change to get the application to run in 'Release mode'?

[ranman256]

Cant you just use the Access runtime?

[ItsMe]

I do not know if I have the solution but I would expect to see

connectionString="Provider=Microsoft.ACE.OLEDB.12.0 ...

In your App.Config file.

I just used the wizard to build a connection string and that is the driver it used. I have Access 2010 (Version 14) installed on this machine and a paid version of Visual Studio. I did not download any drivers. If it is a Windows Desktop App you built I would think the driver would be included with your publication and it would be version 12.

Did you check the Settings under your Project's Properties to see if the App.config matches the Settings file?