I have an update query that uses the left, mid and right functions to cut up a text field. It used to work fine. But now when I run it I get type conversion errors. I copied the table to a new database and run the same update query - it worked fine. It seems there are missing references to those string functions in the original database. Is there any way to check and replace these. The database has too many tables queries and reports to be easily copied to a new database. I have compacted and repaired it. It did not help.
Help please anyone.