title: What are the implications of running a Microsoft access database in both 2003 and 2007?
body: <p>What are the implications of running a Microsoft Access Database in both 2003 and 2007? </p>
  
  <p>Is there some class I forgot to take?</p>
  
  <p>The program was originally built in office 2003, and then run in 2007. Issues seem to happen when the machine it is being run on has both 2003 and 2007 on it. The issue would also appear to stem from reference from the "Microsoft Access 12.0 Object Library" (or the "Microsoft Access 11.0 Object Library" in 2003). To see this, just look at the Tools: Refrences menu on the VBA screen. </p>
  
  <p>The error's symptom is basically the code not be recognized (almost like it doesn’t recognize the programming language I’m using). It usually follows this with a box that says "The expression On Load you entered as the event property settings produced the following error: Object or class does not support the set of events".  You can also replace “On Load” with “On Click” for buttons or “On Change” for text boxes.</p>
  
  <p>I personally suspect that the computer is taking parts of the Microsoft Access 11.0/12.0 Object Library and then mixes the two into a useless VBA reference. What further confirms my suspicion is the box that pops up when going between the two that says "Configuring Microsoft Access" Another issue that further confirms my suspicion is it will run on whichever one it is opened on first (2007, for example) and then not run on the other (2003 continuing the example)</p>
  
  <p>The only other issue is I have had to fix was changing the last part of the DoCmd.OpenForm ,,,,, acFormReadOnly (or acReadOnly, depending on how the machine seems to feel on that particular day - yes it would work with one, one day and then want me to switch it another) to simply locking the individual text boxes</p>
  
  <p>Maybe it’s not quite coding, but I think it might be able to be fixed by coding.</p>
  
  <p>Hopefully that’s enough for someone to come up with something.</p>