Function isn't available in expressions in query expression

[Derek Ruesch]

I have a shared Access 97 database that includes several
linked SQL Server 2000 tables. I also have several queries
that include expressions in them. This database sits on a
server in location A. Everybody in location A can access
the queries without any problems. There are a couple of
users in location B that also access this database. User A
in location B is running Access 97 and can access the
queries without any problems. User B in location B is
running Access 2000 and they can run some of the queries
that include expressions. However when they run Query1
(which has more complex expressions than some of the other
queries) they get the following error message: "Function
isn't available in expressions in query expression." The
Iff() expression is causing the error.

Why is User A able to run the query and User B receives an
error message? What can I do to fix this problem? I
updated the MDAC and Jet Database Engine to MDAC 2.8 and
Jet Database 4.0 SP 8, and I refreshed the references on
User B's computer. This didn't solve the problem.

I posted this question a couple of weeks ago and somebody
suggested disabling sandbox mode. But this only applies to
Access 2003 databases. My database is Access 97.

Thanks for the help.

Derek Ruesch

 

[Albert D. Kallal]

This sounds like a references problem.

Can you create a mde with the a2000 database (on that test computer if this
fails, then you got a ref problem).

I would first try the above..and see what happens. It this fails (you can't
make a mde, then you have a ref problem).

Thus, check your references...

For more info:

Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html


MsKb Articles: 310803, 208218, 209849, 286300

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/default.aspx?scid=kb;en-us;248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803