Justy,

If you accessed your data through views you can use the VFP upsizing wizard and easily make the transition from native tables to an SQL database. If you didn't use views you will need to do some re-writing.

I haven't actually done an upsize - at this point I get data out of an SQL databse, but don't have rights to put any in!

As Nadya said, start a new thread (if you haven't already) and surely someone will help you.



>Justy,
>
>Unfortunately, I don't have experience with VFP+SQL server. At my current work we use VFP native tables only. I'd suggest you to start a new thread for this question. Sorry, can not help you.
>BTW, you can ask Cindy the same question, she is proficient in this field.
>
>>Dear Nadya,
>>
>>Thank you for your help! It's work fine! Do you have to know how can I change the VFP database to SQL server? And How much work I need to change the program? Could you suggest some book about VFP w/ SQL consideration and practical work example? Thanks a lot!
>>
>>Wish you all the best ...
>>
>>Best Regards,
>>
>>Justy Chow