
access table updated by Visual Basic passed on to visual Foxpro
Access 97 has drivers that can connect you to Foxpro dbf's if the dbf is NOT
contained in a dbc. If you are using a dbc, you will need to use Access2K as it
has the appropriate driver.
After you have linked Access to the dbf's, an update query works just as if both
tables were in Access.
One thing to be aware of: if you are writing an insert query, the Access2K
driver converts blanks to Nulls, so if the dbf's are set to not accept Nulls.
you will keep getting errors in the query even though the data you send is not
Null. I learned this the hard way.
Let me know if you need more help.
Michael
(remove SPAMLESS to email me)
Quote:
>Hi!
>I have an Access table being updated by Visual Basic. My question is:
>Can i pass this table to be an input to Visual Foxpro ?
>Thank you in advance.
>Weljie