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?

Any help would be greatly appreciated. I'm at a total loss.

Thanks,

Nichole Brelje