References issue

[John]

Hi

I have sent a client my app where it gives error on an expression. This I am
pretty sure is a references issue as they are using office 2000 and I am
using office xp. As the client is based far away, is it possible to fix the
reference issues remotely somehow? Can I send them sommething that they can
run to fix it?

Thanks

Regards

 

[SA]

John:

If you can provide more information about what refernce is listed as Missing
at the client site then others can provide more help and information.
Without that its difficult to tell.

 

[John]

I think these would be either ms office 2000 or word 2000 (v9 is it?). The
actual error is on ltrim, rtrim functions not being found.

I have experienced this with other clients and I just go in the references,
get rid of the 'MISSING' references, assign reference to the version of
word/office they have, make an mde and I am done.

This client I can't go to and I don't want to send source for them to
compile themselves for obvious reasons.

Thanks

 

[John]

There is a utility to fix references;

http://www.mvps.org/access/modules/mdl0022.htm

But it only works for access 97 and not with access 2000 as I need it to be.

Regards

 

[david epsom dot com dot au]

Here is VBScript demonstrating fixing 'broken' references.
It may help in your case. (you will have to make some
modifications). Note that in general, references may actually
be broken even if .IsBroken and .IsMissing are not true.

(david)
--------------