>I have created a VB program that uses the FoxPro 6.0 Type Library to delete and pack a foxpro dbf.
>
>I tried creating the dbf on the fly but that doesn't work because I am using Crystal 8 to report off of the dbf. If I create the table Crystal errors out that the file is corrupt and not a recognizable file.
>
>I found a suggestion on a thread that said to use the the Foxpro library. I create a new FoxproApplication and am able to successfully delete the records from the table, pack it, populate it with new records and Crystal sees it just fine.
>
>My problem is that I can't figure out what I need to do to distribute it. I am using Wise installation wizard. The vb exe will be run on a local workstation but the exe is actually on a server. When I run the vb program itself it opens correctly. When I hit the print button it errors out "Active X control can't be created" I know it is because of the foxproApplication because if I remove the code and use create table instead it works again, but now I'm back to crystal not recognizing the data.
>
>I am using the crystal report control vs RDC because I want the end user to be able to open up the crystal report and modify it.
>
>What runtime files (both vb and vfp) do I need to distribute to get this to run and where should the files be placed, on the server or the local workstation?
>

You need the VFP runtime library as created by Setup Wizard, or the VSI Merge Module if you're using VSI or a VSI compatible installer to put the VFP runtime in place. There is an article in the UT's VFP FAQ that describes the files needed; I advise you to use either a Setup Wizard runtime install or the VSI module to install the VFP runtime.

You can have VB create an install package for your app to get the VB runtime components needed for your app.

The runtimes should be installed on each workstation that runs the applicable code; if the VFP COM object runs on the workstation, it needs the VFP runtime; if the VB app is run there, the VB runtime is needed, and if both run, then both runtimes will be needed. Unless the server is actually running the components, none of the runtimes go on the server. Crystal Reports also requires runtime files at the workstation.