>When Trying to open a table in a database I get tan error saying xxx.prg does not exist. I click ok and the table opens fine. Is there anyway to overcome this error?

Does it happen with other tables in the DBC? Do you've an index on that table that includes xxx() in the index key? Maybe indexes on that table got corrupted? Did you try

VALIDATE DATABASE RECOVER