>>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.
I see.
This is going to take a consistable amount reviewing their existing code. I am sure my boss is not going to like what I will find and report to him.
Thanks
Greg Reichert