Thant's an interesting solution James. I'll give it some thought. Thanks.

>I hate remote views! To import the data and keep the long table and field names I always create a dsn for the VFP database. Then I go to SQL and use DTS to import the tables into a SQL database.
>
>I use T-SQL and work in cursors rather than remote views. If you can create your application to use cursors to display the data and then close the table, you will not have the problems that arrise when someone forgets to close out of the application.
>
>If you use cursors and T-SQL your "Selects from Cursors" will remain the same for the most part. All you will have to do is add your connection string to the SQL app.
>