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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy