Re: Call PRG from VB with ODBC

Hi Ken,

You can download the latest FoxPro and Visual FoxPro OLE DB data provider
from It works with all
versions of FoxPro tables.

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP

"Ken D" <KenD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> Hi Cindy,
> I am using a DBC for my data source. The reason I need to PACK the db is
> that I am developing a standalone app that will be distributed to many
> users,
> all with their own set of data. I will not be managing the data and I
> need
> the records to be deleted when the user wants them deleted. I tried
> executing the PACK command from VB, but it kept throwing errors. I got a
> "File is in use" error and a "Syntax error or access violation" error. I
> tried your code, but it said the provider was unknown. I do not know if I
> have the OLE DB provider for FoxPro 6 on my computer. Is there somewhere
> I
> can download it? I found ones for FP 8 & 9, but not for 6. Are they the
> same, or is there one just for 6 somewhere?
> Anyway, because VB was giving me errors, I wrote a program (PRG) that
> packed
> the DB and hoped to have it run everytime FP started. However, with the
> information you provided, it looks like that won't happen. Are there
> other
> ways to PACK a DB either in VB or through some sort of stored procedure in
> FP?
> Thanks bunches