>OK - I give up.
>
>I have only ever used VFP is XBASE mode.
>
>We got MSDE with VFP7 which is (presumably) functionally equivalent to MSSQLS.
>
>But how do we us it?
>
>Programatically, what do I do to use the server?
>
>What are the commands to create a new database, create a new table, etc. I know how to use Views - and presumably we use remote views to manipulate the database - but what happens when we want to create a new database on the fly?
>
>And where are our tables stored?
>
>David.
>
>PS This is my Christmas project - get across MSDE/SQLS so I can promise client/server applications to my clients IF I can't talk them out of it!

Perhaps the book "Client/Server Applications with Visual FoxPro and SQL Server" could help you make the transition.

You can get it from http://www.hentzenwerke.com