Error at Runtime (Function not available in querie expressions)

[Gerry]

I have an access program that is packaged and distributed on a network in my
office. The program runs great on some machines and on others it doesn't.
I get a message "Function is not available in expressions in Queries". I am
guessing that maybe this is something to do with security but I can not
figure it out.
The packaged product includes the Access Runtime.
Can somebody make any suggestions?

 

[Klatuu]

It is more likely some of the computers do not have some necessary references
set. Open the VBA editor on a machine where it all works and look at Tools
-> References. Record all the references that are checked. The do the same
on a machine where it does not work. You will likely find there are some not
checked or could be marked as "missing". If one is not checked, check it.
If it says Missing, try to locate the file it references. If it can't be
found, it needs to be installed.

I have seen instances in a corporate environment where a consistent install
was not done and some files were missing. In this case, it is best to
reinstall Access.

 

[Gerry]

Thanks Klatuu,
This happens on computers that only have the Access Runtime installed. How
do I determine what is missing in this case? as I can't open the full access?

Gerry

 

[Klatuu]

What commands are failing? It may be you are doing something that is not
allowed in RunTime. I don't have a list of those, but there are some.

 

[Gerry]

It looks like it is mostly the Mid function that is failing.

Gerry

 

[Klatuu]

Very strange. I have no idea what would cause one function that lives with
other functions to fail in runtime.
Did you get a clean compile before you deployed the application? You should
always be sure of that.

 

[Gerry]

As far as I know, the compile was clean. There was nothing that would
indicate otherwise. What would be the ways to know if the compile was not
clean?

Thanks much!