>But My dear Craig,
>
>Don't you think creating a new file on the disk will be a problem as such always I have to recreate it by zapping and appending the new record and which is not allowed when the exclusive is off, so it is my LAN version, I can't efford to do that as such I tried this method before, Thanks for your suggestion, Is there any other better way to do it.. !!
>
>Also Craig I tried by recreating the views programmatically, but if the view is created programmatically it dosen't works in Crystal reports.. I don't know why..?
>
>Thanks for your reply..
>
>But I would be glad if you can suggest me some better way...


Crystal Reports can only see views stored in the DBC because those are the only views accessable via ODBC. Saving a file on disk work perfectly well.