You get TMPCLP files when there is a broken link. For example, if you create a query based on a table and later on you delete that table but not the query, you will get a TMPCLP file. To know which tables are missing, you can click on Database Tools, Object Dependencies.