"Invalid column name" error when viewing a custom table list view
If you receive an error similar to "Invalid column name TableName_XXXXID" when viewing a custom table in list view, it will be required to rebuild the database's Oledb views manually. This is due to a defect in Act! versions 25 and older therefore, this error may appear in these versions at a higher frequency especially if new tables or fields are added or updated. To rebuild the oledb views, follow the steps described in this article: https://kb.act4work.com/index.php?solution_id=1094