>I am wondering if it makes sense to use VFP as a user interface to a database accessed through MSSQL ? If so, is there any literature anyplace that describes how you do it ?

Try this article by Robert Green on the MS site:

http://msdn.microsoft.com/archive/default.asp?url=/ARCHIVE/en-us/dnarfoxgen/html/msdn_bko01.asp