title: Problem with an MSI distribution
body: <p>So I am continuing testing and releasing changes to my app and I have come across a pain point that I am unsure how to deal with.</p>
  
  <p>First off, my app uses a SQL Server CE database to store information and I need to be able to make changes to this db so I've created an internally updating process that runs whenever the application runs to make sure the db is up to date.</p>
  
  <p>The crux of this internal update process is another SDF file named DBUpdates.sdf that contains all of the db schema changes that need to be applied.</p>
  
  <p>The problem I am having is that the MSI distribution I created will not overwrite this file. It appears that when SQL Server CE opens this file, it changes the Modified date/time of the file. This is a flag to the MSI process that the file has changed, and that it shouldn't overwrite the file. Well now I am seeing that my db changes aren't being applied, because the MSI process thinks the user has changed this file.</p>
  
  <p>At this point I am kind of stumped. I was planning on using an MSI distribution but maybe I can't. What do you think?</p>