>Views doesn't need exclusive access but would be good of course.
>Open database ...
>Drop view ...
>Create SQL view as ...
>works on the fly.

Hey Cetin,

What if I normally do everything through the project manager and I don't have access to the client side except to send them files? or go there? ...which is what I'm really trying to avoid... Is Trey's solution the most viable?

Renoir