Help!
I am using a Mid() function in Expr2. Expr1 is an Instr() function.
The query work fine when I tested it on a table (Access2000) that was imported, but will not work on a table that is linked to an external (Access97) data source. Every time the query is run I get the Error message
"Error: Undefined 'Mid' Function"
I find that If I create the same query on the same external source again It works fine.
I have tried everything I can think of to cure the problem to no avail. All suggestions would be most welcome.
Paul C
I am using a Mid() function in Expr2. Expr1 is an Instr() function.
The query work fine when I tested it on a table (Access2000) that was imported, but will not work on a table that is linked to an external (Access97) data source. Every time the query is run I get the Error message
"Error: Undefined 'Mid' Function"
I find that If I create the same query on the same external source again It works fine.
I have tried everything I can think of to cure the problem to no avail. All suggestions would be most welcome.
Paul C