You will have to connect to MSDE via ODBC either through remote views or SPT. I use a combination of RV's and SPT to access VFP Database, SQL server, Oracle, or other data stores via ODBC. I assume that you can also use ADO, but I have never done that, so I would be of no help there.
One of the things that concerns me with MSDE was that MSDE doesn't have the nifty database management interface tools like SQL Server enterprise manager to create and easily work with the database at a site that doesn't have SQL server installed. For development, I have SQL server and use enterprise manager when developing and testing.
I recently found a tool that may help with database management at the client site or if you do not have SQL server. While I have many SQL Server databases deployed, I haven't deployed an MSDE database and as such have not really tested this tool, but it looks promising. It is called DBaMgr and it looks much like Enterprise manager but is designed for MSDE. You can download it at
http://www.asql.biz/DbaMgr.shtmHTH
>Ok...This is my first time Im goint to try and use a SQL DB (In my case a MSDE)
>
>How can I connect it to my VfoxPro Application???
>
>How Do I do this?? Do I have to use some code, or just in thr project manager???
>
>Please Help Coz this is goin to be my fist time doing this and using the MSDE..
>
>Apreacheate your help...
>
>Thanks...Ya'll