>I searched for this, but didn't find enough to help, so... What is one-of-the-really-great ways (I would say best, but there may be some dissent on that) to send changes in views in the DBC to the client without having to reload all the production data? Can the DBC simply be copied into the app directory without breaking the links to the data? Do I need to recompile and send a new EXE also? What other considerations are there? Thanks!
>
>Regards, Renoir
Renoir,
Views doesn't need exclusive access but would be good of course.
Open database ...
Drop view ...
Create SQL view as ...
works on the fly.
Cetin