JET error: undefined function "InStrRev"

  • Thread starter Thread starter michele
  • Start date Start date
M

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
 
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.
 
So how to use Access Automation?
Thanks,
Michele

Douglas J. Steele said:
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.
Click to expand...
 
Back
Top