Missing EXcel 12.0 Object Library

[Deenos2000]

Access 2003 was upgraded on my machine to 2007. All the other machines in
the office are running 2003. Every attempt to open the database in office
2003 displays this error: Compile error. When I check the references Excel
12.0 Object Library is missing and Word 12.0 Object Library is missing.
Neither of these could be found when I used the object browser. Can anyone
tell me how to solve this issue

 

[Tony Toews [MVP]]

Access 2003 was upgraded on my machine to 2007. All the other machines in
the office are running 2003. Every attempt to open the database in office
2003 displays this error: Compile error. When I check the references Excel
12.0 Object Library is missing and Word 12.0 Object Library is missing.

You want to use Late Binding. This allows your app to use whatever
version of Excel and Word is installed on the system.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

This also is very useful when you don't know version of the external
application will reside on the target system. Or if your organization
is in the middle of moving from one version to another.

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/