Undefined Function 'InStrRev' in Expression

[Guest]

I have 20 installs of WindowsXP at the office. On 19 of them, an application
works. One comes up with an error: Runtime 3805 - Undefined Function
'InStrRev' in expression. The location of the error is a query that has the
"InStrRev" function in a column. If I click the Build... wizard in the
column, to utilize the Expression builder, InStrRev is available from the
Functions > Built-In Functions > Text list.

I have tried to uninstall/reinstall the WindowsXP suite (using the complete
option), but the error still comes up.

Any thoughts?

Thanks,
DanishGuy

 

[Joerg Ackermann]

I have 20 installs of WindowsXP at the office. On 19 of them, an
application works. One comes up with an error: Runtime 3805 -
Undefined Function 'InStrRev' in expression. The location of the
error is a query that has the "InStrRev" function in a column. If I
click the Build... wizard in the column, to utilize the Expression
builder, InStrRev is available from the Functions > Built-In
Functions > Text list.

I have tried to uninstall/reinstall the WindowsXP suite (using the
complete option), but the error still comes up.

Any thoughts?

Check the references

Joerg

 

[Van T. Dinh]

It is likely to be errors in the References Collection of your database.

See Douglas J. Steele's article:

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

 

[david epsom dot com dot au]

InStrRev is an unusual function. If checking your references
doesn't help, and other functions are OK, have a look at this
url:

About Microsoft Jet Expression Service sandbox mode
http://office.microsoft.com/en-us/assistance/HP010446591033.aspx

"The following is a list of things that might not work properly
if you enable sandbox mode before installing the latest Jet
service pack"

I am having this problem on some WinXP PC's. They DO have
the latest Jet service pack, and they DON'T have sandbox mode
enabled, so I haven't found a solution yet.

(david)

 

[Guest]

David:

I think the SandboxMode was the first step in clearing up this problem.
When I went into the 1 machine that is having this 'undefined' problem,
SandboxMode was set to '3' (All the other PCs are set to '2'). After
changing the setting to '2' and after reboot, I am still having the same
problem.

Maybe there is another security registry key that needs to be changed?

Info: Windows2K SP3
MS Access XP SP2

Thanks for your help so far. If I find a solution, I'll post it here. I am
willing to take suggestions too.


-Marc, DanishGuy

 

[david epsom dot com dot au]

The only difference I have found so far between an XP box with
this problem and one without is the version of MSo9.dll: WinXP
updates KB885884 and KB834707. (I'm using Office 2K)
I don't have the opportunity to test that.

Maybe there is another security registry key that needs to be changed?

Potentially, there might be 4 settings: an Office/Access setting
and a Jet setting, under HKey_Local_Machine and under HKey_Current_User.

(david)

 

[Guest]

Check the references
Joerg

 

[Guest]

Check the references
Joerg