access table updated by Visual Basic passed on to visual Foxpro 
Author Message
 access table updated by Visual Basic passed on to visual Foxpro

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



Mon, 16 Dec 2002 03:00:00 GMT  
 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



Sat, 21 Dec 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. PROBLEM: Accessing Foxpro table from Visual Basic

2. Updating Visual FoxPro Table in VB4 through ODBC

3. Update to Visual Foxpro tables fails

4. Unable to update records in Visual FoxPro Table with ADO-ODBC

5. Visual FoxPro indexing in Visual Basic

6. using Visual FoxPro Databases in Visual Basic 6.0

7. Visual Foxpro or Visual Basic

8. Visual Basic 6 and Visual Foxpro

9. visual foxpro or visual basic?

10. Visual Basic 5/6 vs Visual FoxPro 5/6

11. Visual Basic vs Visual FoxPro

12. Can I use Visual Foxpro 5.0 and Visual Basic 5.0

 

 
Powered by phpBB® Forum Software