>I am trying to access Visual FoxPro 5.0 tables from a VB 5.0 application and I have three questions:
>
>1. Can I reindex the database from VB?
>2. Can I pack and remove records marked for deletion from VB?
>3. I have written a stored procedure to generate an incremental index for new records in my tables. This procedure
>works well in VFP, but when I add records from VB it doesn't work at all. Why is this? I thought stored procedures were supported for external access as long as they didn't contain unsupported XBase commands, as specified in the VFP ODBC driver help file?
>
>Thanks,
>
>Brian Hartin
>MCI Telecommunications
>Brian.Hartin@MCI.Com

Brian,

At one point we wrote an application in VB 3.0 and Foxpro 2.6b. The VB app communicated with machines in a factory. The foxrpro app was for data-entry and reporting. We discovered that VB did not support all of the functions that can be used to create index tags. VB was able to use the tags but could not update them properly if functions like dtoc() were used. There were other functions that I do not remember. My experience with VB accessing/updateing Foxpro tables was one that I do not wish to repeat. I hope things are different with VB 5.0. Good luck!