>Update - after opening and modifing each and every view - I found no errors. What I did discover where two temp files (like 0222123.dbf) that where listed in the DBC. I had to create empty file names to get rid of them. I then validated the DBC and all is now working. But where and how did the temp dbf's get created.
>John
If you create a temp table and don't specify free clause (in CREATE TABLE) command, you'll end up with temp files in your DBC. We had this few times. Could it be a reason?
If it's not broken, fix it until it is.
My Blog