>I've written a VOD program using VB & VFP. It works okay, however, I want it to be database driven not have to use work-arounds just to make it work. I perfer to program in VFP, however, VB ran the MPEG ActiveX player better: didn't work quite as well in VFP.
>I have a NT server with 10 to 20 workstations requesting videos. The VB program runs on a Windows 98 workstation whick interfaces with the user making the video request. We've had to use text files in order to get VB & VFP to communicate. Text files were used becuase we couldn't get VB to R/W to VFP database. Really want the whole system to be database driven.
>From what I've read on some of the threads ...
>I could write a COM object, load and run the COM object on a server, then VB (running on a workstation) could use the COM object to R/W to a VFP database(existing on a server).
>Is this, basicly, how it works? Can all my VB programs use the one COM Object at once (muti user)?
>I would appreciate any advice.
>Thank you.

Yes, you basically have it right. Make sure you are using VFP 6.0, and have applied Service Pack 3. It will allow you to use multi-threaded DLL COM servers written in VFP. You should read about COM in the VFP Programmer's Guide and visit the COM web site at www.microsoft.com/com.