Access 2000 SP3 Issues

[Paul Lockwood]

Hello

We have just upgraded all of our machines to Office SP3.
Since doing this I am now getting a large number of errors
within Access db's.

A couple of the errors are as below...

Code on a combo box no longer allows the chr function, so
I have had to use a new function to retrieve the data.

SQL code on a combo box no longer allows the format
function so I can no longer use the format command to
return just the year part of a date.

Thanks in advance for anyone assistance.

Paul

 

[J. Goddard]

The errors indicate that one of the references to dll's may be missing.
While in any code module, go to Tools - References, and see if any of
the references are marked "missing". In particular, look for "utility"
- that's where some of these functions are.

HTH

John