Laurisa,

Our app is Active Document based. It works well in both an Internet and Local setting (we detect if it is running local or remote and adjust the data access automatically). For WEB access, we are using SQL Server 7 over TCP/IP for its security. ODBC is so well integrated with VFP (using SQL Remote Views), that the users can even run in "Offline" mode if they lose the ISP Connection. (Until they tightly integrate ADO within native VFP, it is simply too cumbersome to use, ODBC is proven and works well)

We have a very small HTML page that automatically installs the RT if necessary then redirects the user to the APP file. I can provide you a sample if you like.

See the following KB articles for help:

Q182579: Getting Starting with AD
Q107647: Connecting to SQL Server using TCP/IP Sockets
And Chapter 31: Interoperability and the Internet from the VFP Doc

We have had great success with AD, I would recommend them. But from what I read thats not the fashionable thing to say around here ;)

HTH,
Ed