Hi,
I have a client that is getting 1542 error which is - view does not match the table. This program has been running for years and when we check the view in question from the command window it gives no such error. I noticed that the underlying temp (something like c:\temp\501232.tmp) does not exist. It appears that something has changed and is not creating the temporary tables. Has anyone run into this in the past or can shed some light. Since "C" drive is owned by the user I don't believe it has something to do with permissions.
John