Error during reverse engineering: "Table Name:table_name Catalog: Schema: has not been found. For (49014)

When reverse engineering an MS Access database, the following error message appears:

"Table Name:table_name Catalog: Schema: has not been found. Foreign key will not be created."

The table referenced in the error message actually exists in the database when viewed from Microsoft Access.

Toad Data Modeler Reverse Engineering is case sensitive while MS Access is not.   A particular table name in the MS Access model is in uppercase while in other places, the same table name was referenced in lowercase.

1. Open the database model  using Microsoft  Access
2. From the navigation pane on the left hand side, right-click on table in question and select Rename
3. Type in the same name (e.g. EMPLOYEE), in upper case.   This should fix the names on all other places.
4. Save the model
5. Open Toad for Data Modeler
6. Reverse Engineer the MS Access database