The cause is definitely an index on the view. Remove the index and the view from a views dbc that is compiled in works fine. Ad the index on the view and you get an error indicating you cannot write to the table ( it is in the VFE cursor class method that creates the indexes on the views ) Have done EVERYTHING I or anyone else can think of re permissions etc. Seems to be machine specific.
>Hey Charles,
>
>
>>On some boxes a view with indexes ( created from metadata in VFE ) will crash on opening. Excluding views dbc solves the problem.
>
>I remember reading some of your other posts on this, but now I'm seeing something which sounds similar and might be related (Since moving an app to VFP8).
>
>Do you get an error# logged?
>
>Is the error confined to only some views?
>
>Local or remote data source?
>
>Did you try SET TABLEVALIDATE TO 0?
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.