>>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,
>Looks like there needs to be better peer support in this forum! Anyway, here is my, somewhat small, experience working with Foxpro tables with VB. I've tried to access Foxpro tables using VB4 before without success. I couldn't do those things you are inquiring (reindex, pack, etc) and in addition, could'nt find a way to not show deleted records. VB, it seems, gives you access to add, edit, view but nothing more. I haven't worked with VB5 or VFP ODBC drivers yet but I don't believe too much have changed.
>
>My suggestion is to use Visual Foxpro 5.0 for front end or use third-party database manager (like CodeBase from Sequiter Software Inc.) to access the tables.
>
>John
Have you considered a VFP automation server to wrapper the database functions? Expose the needed methods and use them from VB as you would anyother server. This allows the full capabilities of VFP to be exploited and possible offload some of the field/record/multiuser functions.
HTH