Microsoft CDO 1.21 Library Reference

[Guest]

Hi,

I am trying to open an access database but everytime a debugging error keeps
appearing because a reference library component is missing. Basically to
investigate this, I have gone into the visual basic code editor, clicked on
Tools and then Reference and noticed in the reference dialog box that it has
the following component is missing:
The component is checked and reads "MISSING: Microsoft CDO 1.21 Library", so
what i do is uncheck that option, click on OK and exit the database and go
back in. Fixing that helps me get in the database correctly but the next day
or even a few days after, the error re-appears and i have to go through the
process of unchecking the option in the references dialog box again.

What can i do to resolve this issue in Access, so that the error message
does not keep occuring?

Thanks in advance.

Nadeem

 

[Douglas J Steele]

Access doesn't add libraries back after you've removed them, so it must be
coming back in some other way.

Is a new copy of the database replacing the database which you fixed? Is
someone else working on the same database?

 

[Guest]

Yes thats right a new copy does replace the database, as we update the
version of the database on an almost daily basis. The database (which is
located on the server) is used bu several users but i am the only one with
the issue, so i guess it must be somthing to do with my PC and Acccess
settings.

Any suggestions then.

Thanks in advance

 

[Douglas J Steele]

The problem is caused by the fact that the program is trying to use a file
(whatever file's associated with Microsoft CDO 1.21 Library) that either you
don't have on your machine, or you have a different version than on the
machine where the database is being developed.

On a machine where the application works, determine what file is associated
with Microsoft CDO 1.21 Library, determine where it exists on that machine
and what version it is.

Look for the same file on your machine. If you're missing the file, or you
have an older version, you need to install it. (Afraid I don't know enough
about CDO to know whether or not it's as simple as copying the one file and
registering it using regsvr32.exe).

If you have a newer version, either the developer (and all other users) will
have to upgrade, or the developer could try using Late Binding instead.