What else would you do 100% SQL Pass through? I am poised at looking at SQL Server or MSDE as the back end replacing VFP tables where all access is defined in the DE of the form.

__Stephen

>I keep all my views in PRG files, and when I need to change them I update the code and then run the PRG to update the DBC. Since I'm using Remote Views for a project (no comments, please, it wasn't entirely my idea) this is an easy way to update them when the underlying SQL-Server structure is changed which the DBA seems to do regularly.
>
>HTH
>Barbara
>