Onclick error on query that's ok?

[Guest]

We have a multi user database which is FE/BE. Every so often I have to make
a change to the database code or whatever, and then re-create the MDE file.
I then copy that into the 'public domain' for the users to access, and
everything's fine. Once or twice I've forgotten to make sure everyone is out
of the database before doing this, and it causes problems, so I just re-copy
the MDE file and everything is fine.

I did this yesterday though after making a minor change that wouldn't affect
anything (just to do with one person's login) and now I'm getting an odd
situation...

The MDE opens with a main menu not linked to any table. You click on a
button and it would take you, for example, to the Equipment form, with Filter
by Form on. The form is based on a query which calculates next inspection
dates. The form, query and tables are all fine - I've been through them,
compiled, re-linked, compacted and repaired. No problems - and it's been
used all the time.

What happens now though, is that when someone clicks on the button to open
the form, there's an OnClick error saying a Function is not available in
query expression blahblahblah. The query is fine though.

But the strange thing is that this doesn't happen for everyone, and if I
recopy the MDE then a person who could get in can't, but another might be
able to.

 

[GeoffG]

What happens now though, is that when someone clicks on the button to open

the form, there's an OnClick error saying a Function is not available in
query expression blahblahblah. The query is fine though.

I've noticed something similar in Access 2002. A public function called
from a query sometimes produces a similar error. As you may know, Access
2002 is now only in extended support mode, ie past the end of its
development cycle. Does that gives you a lead? Sorry, I have no other
information that'd help.

Geoff