JET error: undefined function "InStrRev"

[michele]

Hi all,
i'm using a query in my database that calls the function InStrRev;
the query work fine in Access, but if i try to access it using Microsoft Jet
(from an external app), i receive the error:

undefined function "InStrRev"

Is there a solution?
Thanks

 

[Douglas J. Steele]

InStrRev is a VBA function. Jet doesn't know about most VBA functions.
There's no real workaround other than using Access Automation, which isn't
always possible.

 

[joun]

So how to use Access Automation?
Thanks,
Michele

InStrRev is a VBA function. Jet doesn't know about most VBA functions.
There's no real workaround other than using Access Automation, which isn't
always possible.