The error occurs when the framework's cursor class attempts to index the view. The view opens and then when the command is given to index the view there is a "cannot write to the table" error. (I've stepped through this one in developer mode on the boxes where it is a problem) Can't reproduce the problem on half of the machines I try it on. Remove index and view opens fine. Open the view in developer mode and issue index command and there is no problem. Exclude the view from the EXE and there is no problem


>Hi charles,
>
>>I've been doing this as well, but recently I've run into a problem. It seems to only happen on some Windows XP pro boxes. config file brings tmpfiles to local \temp. Data files on server, EXE running locally. views dbc compiled in.
>
>>On some boxes a view with indexes ( created from metadata in VFE ) will crash on opening. Excluding views dbc solves the problem. Can't reproduce it on any of my dev boxes and on half my client boxes ( even those that shared a common data store on the network. ) Permissions are identical. My only suspicion is it has something to do with which updates are installed though I can't track that.
>
>>Have you seen anything like this?
>
>Well what kind of error you get? a C00005? or another descriptive error (if so what error). I've identified a problem with views and indexes using in transactions and submitted a bug reports to MS, which has been confirmed here by MS on the UT. Maybe it is related.
>
>For the rest I don't get any reports of malfunction, though I'm not that close to the end-user. Approximately 20 clients and 100 users are working with this approach for a year or two now. Did not have any report of any problem pointing in this direction.
>
>Walter,