replace function in Access 2000

[Anvoy]

Hi everyone,
I have a strange problem. I have a function which
takes care of the apostrophe normally not handled in Sql
queries in access. I use the replace function to replace
the apostrophe with the Ascii value (chr(39)).
This solution works on my p.c. It also worked on my
managers p.c. but she made some changes to the Access DB
(like changing the security) and changed some other forms
etc. on her p.c. Now the replace function doesnot work on
her p.c. she gets a run time error 3075, "Function is not
available in expressions in query expression.."
Has this something to do with some settings of Access 2000
which is different on the 2 p.c's?

Thanks
Anvoy.

 

[Timothy C. Doherty]

This is usually caused by a missing reference or dependency file.
Double-check your references and any dependency files (dll's, etc) used by
your references...