Undefined function 'replace' in expression

[vidas]

Hi,

Problem only and only with access 2000 in computer at home.
My work computer ok. On both computers WIN-XP.
Office 2000 from the same CD.

SELECT left("AB",1) - ok.
SELECT replace("AB","A","X") - Undefined function 'replace' in
expression.
REPLACE in imediate window is working ok.

Module UsysVB (imported from ACCESS97):
#If VBA6 Then
#Else
Function replace(txt As String, old As String, neww As String) As String
.....
#end if

 

[Ken Snell [MVP]]

The Replace function did not work in queries in the early version of ACCESS
2000. Get and install the latest updates for ACCESS 2000 and Jet to fix this
problem.

See these Microsoft.com links:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
http://office.microsoft.com/en-us/officeupdate/CD010226001033.aspx