Publish error while Modifing Any CPU to x86 on Exisiting Click Once Deployment

[EDN Admin]

<span>Hi All,<br/>

<span>
<span>I have developed one small desktop application which will import excel data and update into database using
<span style="color:#a31515; font-size:x-small

<span>I dont want the user to install Microsoft.ACE.OLEDB.12.0 for 64 bit because they dont like to install . AFter I read all of the forum from google and found that to change the Target CPU to x86 will help to fix the issue.
When I change the target CPU of my clickonce application from "Any CPU" to "x86" in Advanced compile options of the project properties, and publish the latest version to a shared location, I get a pop up message saying "The applicatin platform does not match
the existing application on the server. Do you want to overwrite it." with Yes and No options. When I say Yes then the app is successfully published to the shared location. But when I start the app (auto update clickonce), it gives a message "The application
cannot be started". The error details are as given below.<br/>
<br/>
- System.Deployment.Application.DeploymentException (SubscriptionState)<br/>
- The deployment identity does not match the subscription.<br/>
- Source: System.Deployment<br/>
- Stack trace:<br/>
at System.Deployment.Application.SubscriptionStore.CheckUpdateInManifest(SubscriptionState subState, AssemblyManifest deployment, Version currentVersion)<br/>
at System.Deployment.Application.ApplicationActivator.PerformDeploymentUpdate(SubscriptionState subState)<br/>
at System.Deployment.Application.ApplicationActivator.ProcessOrFollowShortcut(String shortcutFile, TempFile& deployFile)<br/>
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)<br/>
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)<br/>
<br/>
<br/>
------------------------------------------<br/>
<br/>
To get the application working, I had to uninstall the application and install the latest version. Is there a way to prevent the unistall and install, on changing the target CPU of a clickonce application.<br/>
<br/>
Thanks in advance

Muru

<span style="color:#a31515; font-size:x-small


Provider=Microsoft.ACE.OLEDB.12.0 Oledb Provider.
It is working fine with all of my client user PC who hs windows XP and MS Office 2007 but it is not working on the user who has WIndows 7 and MS Office 2010. It gives me error like " The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been
registered" .

View the full article