bolsooi31
04-21-2011, 02:19 PM
Today’s guest writer is Lois Wang—PM for reports and version-to-version compatibility. I saw a question on the Access TechNet Forum the other day that I’d like to share with the community:“I can't open accdb files in Access 2007 after they've been opened in 2010.”Access 2010 brings you many new features (Data Macros,Microsoft Office 2007 (http://www.windows7-key.de/office-2007-key), Calculated Columns,Windows 7 Pro (http://www.microsoftoffice2010key.net/windows-7-key), etc.) that Access 2007 does not understand. If Access 2007 goes ahead and open a Database created/modified in 2010, it will ignore these new features and might even cause data loss or corrupt business logic. For example, a data macro validation rule that is forced in 2010 but ignored in 2007, this can cause data inconsistency. To prevent that from happening,Office 2007 Serial (http://www.office-2010-key.de/office-2007-key), we implemented the feature to block certain databases to open in Access 2007 after it's modified in 2010, or open it as read-only in 2007. Access 2007 cannot open a database built or modified in Access 2010 if it uses:new sort orders,Access 2010 new encryption, oryour application has been published to SharePoint. For other new features as Data Macros, Calculated Columns, Navigation controls,Microsoft Office 2010 (http://www.microsoftoffice2007key.net/office-2010-key), Web browser controls, and new layout for forms/reports, we did the work to allow the Access application that contains these features to open up in Access 2007 SP2, but objects containing these features are read-only. However, the application does not open in Access 2007 SP1,Office 2010 (http://www.msoffice2007key.com/office-2010-key), so please make sure you get SP2 for Access 2007.What if the people you want to share your application with only has Access 2007? There is a way to “down-grade” your 2010 application to 2007. In short, delete the new features in your application and import all objects into a new Access 2010 blank application. This will create a new app that can work in Access 2007. The article on has more details. <div