"Function Isn't available in expressions..." error

[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.

Thanks for the help.

Derek Ruesch

 

[Allen Browne]

You may need to disable sandbox mode.

See:
"Enable or disable sandbox mode:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

"Functions and properties that are blocked in sandbox mode:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

 

[Raghu Prakash]

Hi Derek,

ACC2000: InputBox Error: Function Isn't Available in Expressions
Microsoft Knowledge Base Article - 198955
http://support.microsoft.com/default.aspx?scid=kb;en-us;198955

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.