Access/Office 2000 to 2003 - MS Word/Outlook object libraries?

[Paul Kraemer]

Hi,

I have an Access 2000 application database (.mdb) that I want to upgrade to
Access 2003, but I want to try it out on a test PC just in case it doesn't
work. I installed Office 2003 on the test PC. I am trying to open the
database in Access, but Access complains that it has missing references the
following missing references:

MS Word 9.0 Object Library (msword9.olb)
MS Outlook 9.0 Object Library (msoutl9.olb)

I believe these libraries are used by the Access application when it
automatically generates emails and word documents. These are important
features that I can't do away with.

I cannot seem to find the above libraries on the test PC. I was hoping I
would find newer Office 2003 versions of the same libraries. I was guessing
that these would be called MS Word/Outlook 11.0 Object Library with similar
filenames (msword11.olb / msoutl11.olb). I can't find anything even close to
this.

Can anyone tell me if the libraries I am looking for were discontinued? If
so, is there a way I can install and use the older libraries? Or, will I
have to rewrite the code for automatic email and word document generation so
that it uses more modern techniques?

Any advice will be greatly appreciated.

Thanks in advance,
Paul

 

[Rui]

They definitely still exist.

Instead of looking for the filenames (if you did it with the search tool on
windows, it is likely it wouldn't find but they will be there). Open the vba
code window, then tools and click references.

in it you should be able to find both Microsoft Word XX Object Library and
Microsoft
outlook XX object library.

hope this helps
Rui

 

[Albert D. Kallal]

I cannot seem to find the above libraries on the test PC. I was hoping I
would find newer Office 2003 versions of the same libraries. I was
guessing
that these would be called MS Word/Outlook 11.0 Object Library with
similar
filenames (msword11.olb / msoutl11.olb). I can't find anything even close
to
this.

The libraries will not appear unless you install the software. So, if you
using the word library, then word will have to be installed.
(you were not thinking you can use word without word installed...hum!!!).

Can anyone tell me if the libraries I am looking for were discontinued?
If
so, is there a way I can install and use the older libraries? Or, will I
have to rewrite the code for automatic email and word document generation
so
that it uses more modern techniques?

All of your automaton code should work just fine. You have two choices:

1)
after you install word + outlook, then you will find the office 11
references.
(thus, simply remove/delete the old references, and add the new ones via
tools->references when viewing code).

2) using late binding, so your code will work with

access97, acccess 2000, access 2002, access 2003, access 20007
and the above will work with ANY compbisind of

access97, and outlook 97, outloook 2000, outlook 2002, outlook 2003, outlook
2007

access 2000 and outlook 97, outlook 2000, outlook 2002, outlook 2003,
outlook 2007

and....so on. You get the picture, as you can see, there is quite a few
combinations here. Recalling my math permutations, I count 125 different
setups you can have for setting those references if we take just the
last 5 versions of office.

So, if you don't want to set the office 11 references, or not want to
maintain
this stuff evey time you upgrade, or install to a computer with a different
version
of word, or outlook, then simple solution is to use late binding. You can
read
more about it here:

Late Binding in Microsoft Access
http://www.granite.ab.ca/access/latebinding.htm

The other advantage of late binding is that if a user don't have outlook
installed, then your code will STILL run as long as they don't use the
outlook features in your software...

 

[Pieter Wijnen]

That is all valid albert, but you could add: 'using early binding is fine
for development purposes, ie accessing the methods & properties of the
object model, but should be changed to late binding in a production system'
or words to that effect

mnsho

Pieter