Check out the series "A VFP/SQL Server application from the begining" in the UT Magazine (
http://www.utmag.com/May2003/Page36.asp)
HTH
>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?