title: Creating an MDE 2003 file from Access 2010
body: <p>I run MS Access 2010 on my home PC and I've been building a database for work.</p>
  
  <p>Most workstations at work don't run Access to build databases, but they do allow us to run MDE files for applications already built.</p>
  
  <p>I saved my database as a 2002-2003 database and then published it as an MDE file. All worked really well. I tested the MDE file on my PC at home and the automatic re-linking to the back end db worked and the database popped up. Awesome.</p>
  
  <p>The problem came when I tried to run it on the workstation. It came up with an unrecognized format and suggest I change the version on the database.</p>
  
  <p>So, back to the drawing board. I did some research and from all indications from other forums and sites, you cant build MDE files for 2002-2003 databases using Access 2007 or 2010, even though the option is clearly there.</p>
  
  <p>Suggestions were to load Access 2003 to the PC an build the database using this. OK, did that, imported all of the items from the 2003 database created in Access 2010 to a blank db created in 2003 and I get nothing but errors. Incidentally the database was originally build from and access 2003 database at work! Unfortunately, I no longer have access to that particular workstation.</p>
  
  <p>So that's the dilemma. The question / discussion im after is how to resolve this and get the database, preferably from my office 2010 suite into a standalone system of some type working from a Windows XP workstation at work.</p>
  
  <p>I need to find a way to be able to build these tools at home and use them at work. BTW, upgrading the workstations at work is not an option. believe me the organisation is too large to even consider a change like that, WAY too much bureaucracy..</p>