Check out the Craig Berntsten article on VFP with COM+ - it talks about a simple COM+/mtdll setup with security impersonation (which should solve your problem):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxtk01/html/ft01e1.asp?frame=trueSpecifically, "Once you've built your component, you install it on the server with the appropriate VFP runtime libraries. Then, you create an MTS package and import your component using the MTS Explorer. Using MTS Explorer, you can set security and transactional support, and export a client setup program."
>I have developed a ASP and VFP MTDLL web site. When using VFP scripting I have no problems accessing data that is located on the computer hosting the web site. However, I am having trouble accessing data that is located on another computer on the network. The sql code runs fine in the IDE, or an EXE, but when running it in a vfp mtdll I cannot access the data.
>
>Anyone have any idea what is preventing getting access to the data?
>
>Gaylen