BikeToWork
Programmer
There is a networked Access database shared by some users with Office 2007 and others with Office 2010 installed on their computers. The database is set up in 2007 (whose accdb format opens natively in 2010). Unfortunately, if a 2010 user changes the design of an object, the database automatically inserts the Microsoft Excel 14.0 object library reference and removes the Excel 12.0 library reference. After this, when a 2007 user attempts to use the database the code freaks out because the Excel 12.0 reference is gone and the Excel 14.0 library is missing. Does anyone know of a workaround for this? Thank you in advance for any advice.