Hi, this is the first time I've posted an article so here goes...

I am fairly new to Visual Basic and I am developing a prototype
that will access a FoxPro database.  I'm writing to see if you  
experienced Visual Basic folks know of any things I should watch
out for - pitfalls or problems - when accessing FoxPro from Visual
Basic.  I have reviewed the articles already posted and am aware
of the Installable ISAMS issues.  Is there anything else?  Any
issues regarding indexes?

Also, I have few examples of FoxPro table access and even of
multi-table access.  For multi-table access, I've only found the
"biblio" sample that came with Visual Basic.  The few
reference books I have tell me how to access one table with
Data Control.  I would appreciate suggestions of some good
references for data access with examples.      

My FoxPro database is fully normalized, with numerous tables
linked by primary and foreign keys.  (The database was created
with a database generator product.)  I'll want to be able to
read and write to the database from the VB prototype.  I'll want
to show multiple tables on one form.  The prototype will ask the
user to select a primary key and then related information from the
database will populate a number of forms.

Any advice would be greatly appreciated.  Thanks.

If you have any indexes that consist of multiple fields or involve Xbase
functions, they will not be used or updated by VB/Jet.  If your tables are
large, then you'll get pretty slow results on queries.  So, I switched
to SuccessWare's Rocket.

Good choice.  Based on experience, I've come to rely on Data Access.  Bound
data controls are nice.  You can't beat the functionality you get in such a
small amount of effort.  However, you get little flexibility on when and how
things are saved.  I found myself fighting the bound controls more than
utilizing them.  For this, I've switched to using Data Access.  With the Rocket,
you'll want to use Data Access-like techniques anyway.

If you're going to do much work with VB and FoxPro DBF files, give
SuccessWare a call at (909) 699-9657 and ask for information on the
Rocket.  I think you'll find it worth the $150.  Especially if you
plan on creating multi-user add/edit/delete-type applications.

If you're not constrained to the DBF format, consider moving the data
to an Access/MDB format.

--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
: Shannon Thornton                       : U.S. Army Corps of Engineers :

: #include <std.disclaimer>              :           Computer Scientist :
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+