Hello Aaron,

I wouldn't presume to tell you what to do. It sounds like you have a good handle on what to do anyway. If you're going with SQL Server for your back-end data server, you might want to checkout the Microsoft Data Engine for your modeling phase. If you haven't seen it, it's basically a limited version of SQL Server. You could set up your data the same way you would with SQL Server and write most of the VFP code you need to model your system before committing to any final design solutions and before shelling out the bucks for a copy SQL Server. I've seen it mentioned here on the UT but haven't had any personal experience with it.

Good luck,

Gregg



>Thanks for your reply!
>
>
>In fact, i am working on that....
>
>i want to set up a server in my main office, and letting several other office to gain access into the main, to pull out data. To minimize the cost, local telephone system is being employed.
>
>In my plan, i would like to set up a SQL server in Window NT for the Server, the clients will be using remote views.
>
>1. i planned to set up the remote views, to see how this works, how much do i need to change the programs and so on.
>
>2. Set up the server afterwards.
>
>
>Please tell me what should i do!
>
>Thank you
>
>Aaron Chu