>i created a database in VFP, what i an trying to do is have a connection in SQL Server 2000 and access the tables there(like add,edit,delete and etc.) can you help me how to do it step by step?

There're few articles on MS site that should get you started
- http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarfoxgen/html/msdn_bko02.asp
- http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarfoxgen/html/msdn_bko01.asp?frame=true
Don't forget about book Client-Server Applications with Visual FoxPro and SQL Server 7.0 http://www.hentzenwerke.com/catalogpricelists/csvfp.htm