>ok my question is that i already have a program running with the dbf database and i want to change the database to be more fast. So do i have to redo all the program for the database access or can i do something more fast
>
>thanks !

First, you have to do a lot of things. If your program doesn't run a big network has a lot of terminals, be sure .dbf version will ron faster than sql-server version.
In small networks .dbf version run faster but big networks because of network traffic, sql-server version will faster.

To run your program in sql-server:
first: you have to descript a connection for sql-server. It's the easiest step. Unfurtunately I remember I difficultly done it. :(

In sql server you don't get all of rows for big tables. You don't use seek command for search records for big tables. It's a sample search:

mycust="ahmet"
sqlexec(myhand,"select * from customers where cust_name=?mycust")

I learned how I programming with SQL-SERVER VFP's help, SQL-SERVER Books online and UT folks. I didn't bought any book.
In VFP's help connect and use sql-server decribed step-by-step and be sure you cannot found like that other any language.