none
Problems between Access 2007 and 2010 RRS feed

  • Question

  • The original database was programmed in Access 2007, then I give it to my colleauges who use Access 2010. The Problem is that somehow the surface seems to be different, labels didn't show up like in 2007.

    What can I do? I guess there are problems with compatibility.

    The next problems is that if I open it in 2013 and then without saving in 2007, it causes error, you can not open any formulars anymore. What is the problem?

    thanks

    Monday, August 1, 2016 8:53 AM

Answers

  • They don't display at all?  Or they show up differently?

    Have you performed a Compact and Repair?
    Does your db compile without errors?
    Are your users running Office themes?

    Once a user opens the db on a newer version Access can take certain liberties and change the file format and thus making it useless on older versions.

    You have to set yourself up for development.

    • Split your db if it isn't already done.
    • Distribute a copy of the FE to each user (you retain the master copy for development

    This way your users do not impact your master copy.  They can report issues to you, and you perform development on your copy and when you are ready you release a newer version of the FE to them.


    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Monday, August 1, 2016 4:56 PM

All replies

  • I don't know why labels are not showing in 2010. Versions 2007 opened in 2010 are usually very compatible.

    What error do you get when opening in 2013 and then 2007?


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, August 1, 2016 2:52 PM
  • They don't display at all?  Or they show up differently?

    Have you performed a Compact and Repair?
    Does your db compile without errors?
    Are your users running Office themes?

    Once a user opens the db on a newer version Access can take certain liberties and change the file format and thus making it useless on older versions.

    You have to set yourself up for development.

    • Split your db if it isn't already done.
    • Distribute a copy of the FE to each user (you retain the master copy for development

    This way your users do not impact your master copy.  They can report issues to you, and you perform development on your copy and when you are ready you release a newer version of the FE to them.


    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Monday, August 1, 2016 4:56 PM
  • I don't know why labels are not showing in 2010. Versions 2007 opened in 2010 are usually very compatible.

    What error do you get when opening in 2013 and then 2007?


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    thanks for responding. they shows differently, the label "information" was on one line, but at the colleagues' pc it shows on the second line.

    I can not tested now, but I remember it said that something is missing, when I try to open it in 2007, after I use it in 2013 before. But I think like Daniel said before, maybe the MS Version of 2013 automatically referred to a library which doesn't available in 2007. I have to check it again.

    • Proposed as answer by David_JunFeng Thursday, August 11, 2016 1:51 PM
    Tuesday, August 2, 2016 8:30 AM
  • They don't display at all?  Or they show up differently?

    Have you performed a Compact and Repair?
    Does your db compile without errors?
    Are your users running Office themes?

    Once a user opens the db on a newer version Access can take certain liberties and change the file format and thus making it useless on older versions.

    You have to set yourself up for development.

    • Split your db if it isn't already done.
    • Distribute a copy of the FE to each user (you retain the master copy for development

    This way your users do not impact your master copy.  They can report issues to you, and you perform development on your copy and when you are ready you release a newer version of the FE to them.


    Daniel Pineault, 2010-2012 Microsoft MVP

    Thanks for your help, I will test it.

    Tuesday, August 2, 2016 8:31 AM
  • Hi cookie_schoko,

    Have you tested it with Bill and Daniel's suggestion? do you have any progress or resolve your issue? If you have any issue, please feel free to let us know, we will supply help.

    Thanks for your understanding.
    Thursday, August 4, 2016 9:28 AM