Re: Call PRG from VB with ODBC



Hi Ken,

You can download the latest FoxPro and Visual FoxPro OLE DB data provider
from msdn.microsoft.com/vfoxpro/downloads/updates. It works with all
versions of FoxPro tables.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"Ken D" <KenD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2F6B02BA-3AAB-4194-A56E-4BDB0293F84D@xxxxxxxxxxxxxxxx
> 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


.