Excel code libray error when updating MS2003 from Ms2007

[tekkyun]

Hi,
I am responsible for maintaining a number of ms access databases on our company network. These are all written in access version 2000/2003 and all use the Excel 11 code library.
I have recently upgraded my pc to office 2007 and now find that when I perform any updates the code library automatically updates to Excel 12 even though I have not converted the databases to 2007.
As many of our users still use office 2003, they now find that the database is non functioning (blank screen).
The only way I can see to correct is to open the database on a computer running office 2003 and re-instate the excel 11 code library.

Does anyone know a fix to allow ms 2000/ 2003 Db to be updated from pc that is running office 2007 / access 2007 without having to perform this manual fix each time?

 

[Hap007]

Seems Microsoft tries to help you by updating the reference to your most recent version.

1) You could remove Excel 12 from your development PC
or
2) You could try adding the library reference at startup time using VBA code. That way, the most current version for the PC would be loaded.

Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121