Missing string function reference (Access 97 SR2)

[TonyM]

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.

[MarkLiquorman]

You are right when you say Access has lost it's references. To fix, just open any module or go into De######. Then from Main Menu Bar, select Tools | References. Scan the list for any reference listed as "Missing". Make note of which one it is, then uncheck it and and close the box. Now, open the list back up again and find that same reference. Select it and close the box again. This should clear-up the problem.

[TonyM]

Thanks - it now works again.