Using VB App. to call dbf files if DBC is a different location?

[OasisChurch]

Hi all,
How does one use a VB App. to call the tables if the the tables are pointing to a different location in the dbc?
Is there a way to set this location?

This will need to be done on workstations that do not have FoxPro.

Is this possible?
thanks in advance!!
--scotta

 

[rgbean]

You should be able to open whatever tables and databases you want using the VFP 7/8 OLEDB provider - you just need to own one or the other to distibute this .DLL.

Rick

 

[OasisChurch]

Thanks for the response, however in our VB apps. we do not use OLEDB but ODBC. Any suggestions?
thanks rgbean
--scotta

 

[Mike Lewis]

Scotta,

In the ODBC setup window, set the database type to "Visual Foxpro database" (NOT "free table directory&quot, and set the path to the path and filename of the DBC.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk