title: Convert Access 2010 accdb to 2007 accdb
body: <p>I'm trying to convert an accdb file from use in Access 2010 to Access 2007. I first tried opening the file with Access 2007 and I get the error <code>Unrecognized database format</code>. I was able to get my backend to open in 2007 by removing the <code>MSysResources</code> table (which uses the new attachment datatype) but the same technique has not worked with my front end.</p>
  
  <p>My front end does use a webbrowser control (which Microsoft claims won't work but also won't stop the file form being opened). I thought I'd better import one form at a time to see where the error is. While in a new, blank 2007 file I tried to use <code>External Data</code>><code>Access</code> to import one form (a very simple form, a button, two text boxes). Same error as opening the whole file. I tried having 2010 open at the same time as 2007 and copy/pasting the form over. Same error. <code>Unrecognized database format</code>.  </p>
  
  <p>I then try to export the form using <code>Application.SaveAsText</code> in 2010 and import using <code>Application.LoadFromText</code> in 2007. There were errors importing but at least this method generates an error log. The <code>error.txt</code> file has issue with the header line <code>PublishOption =1</code>. After I remove that I continually get errors regarding theme settings. I remove every line it has a problem with which are from there on all theme related (<code>HoverForeThemeColorIndex</code>, <code>AlternateBackThemeColorIndex</code>...). I never did get rid of enough of these to successfully import the form though.</p>
  
  <p>Where am I going wrong? If, like I suspect, I cannot use a theme generated in 2010 in 2007, how can I remove all these references from all my forms? Is this actually the problem? How can I more smoothly move back to a 2007 file?</p>
  
  <p><strong>Edit:</strong> It turns out the client is on Office 2007 SP2. I'm going to update my development machine and try all this again. I was not using nay service packs originally.</p>