undefined function 'replace'

[Guest]

I have a saved query object with a replace function embedded in it (update xx
set xx=replace(xx,'|','EOR'). This query works in several different Windows
environments except one. I have checked references in a test database and
they are all there. I cannot check the references for the database in
question because it is a .mde database where I cannot get to the reference
window at all.

The environment in question is running Access 2000 with SQL Server as the
backend database (split database).

Any ideas?

 

[Douglas J. Steele]

Sounds as though you haven't applied all of the service packs to your
installation of Access 2000.

If that doesn't solve it (or if you're unable to upgrade), you can create a
wrapper function that calls the built-in Replace function, and then use your
wrapper function in the query.

Something like:

Function MyReplace( _
InputString As Variant, _
ChangeFrom As String, _
ChangeTo As String _
) As String

MyReplace = Replace(InputString, ChangeFrom, ChangeTo)

End Function