I am referencing MS Excel 12.0 and MS Access 12.0 Object Libraries in an Access 2007 Database. When I open this with an Access 2007 version, both references stay as 12.0.
When I open the database with Access 2010, the Access 12.0 gets changed to Access 14.0 and Excel 12.0 gets changed to Excel 14.0 and everything is still fine.
However, if I open it in Access 2010, then close it, it appears that the Excel Reference is saved as Excel 14.0. If I then open it in an Access 2007 version, the Access Object Library changes back to Access 12.0 Object Library and is located in C:\Program Files\Microsoft Office\Office12\MSACC.OLB. However, the Excel Object Library remains as Excel 14.0 Object Library, is flagged as MISSING and shows the Location as C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE and, of course, since the User is using Office 2007, can't find it.
Any suggestions would be appreciated.
Thanks, Eddie