>Hi all,
>
>I am investing what it would take to convert database from local to SQL server. I am looking upsize the tables to SQL and access then via remote views. I realize there far better ways to achieve this other te remote views, but it is a question of time to delievery at stake.
>
>While, the question I am asking; can index be created against the remote views so I do not have to change all SET ORDER TO stateements?
>
>Greg
Yes, you can index remote view, i.e. cursor behind it. In regard to using, it depends on existing application design. I found that in most cases it's more natural to call server stored procedures (through SQLExec), and get data from the server to local cursor by the same way, i.e. you may 'run' the same Select statements that you use now.
Edward Pikman
Independent Consultant