none
VB 2008 and access 2007 relationship RRS feed

  • Question

  • I have a Access 2007 file that I am using in VB 2008.  I am having problem with relationship in VB. The relationship works fine in Access but it wont work in VB. it saves data on first table but not on other. I have use dataset wizard in VB  to insert table info in VB.

    Wednesday, March 9, 2011 5:18 AM

Answers

  • Hi Parvanah,

    Thank you for posting.

    >> I am having problem with relationship in VB. The relationship works fine in Access but it wont work in VB. it saves data on first table but not on other.

    It should be ok via VB.NET. Can you show me some code snippet so that I can do further research about your problem?

    And what's the relationship between the tables? Can you give the table definition and the relationship Id?

    Please take a look at this article: http://www.codeproject.com/KB/database/relationaladonet.aspx which introduces inserting relational data using DataSet and DataAdapter.

    I hope this can help you and feel free to follow up after you have tried the sample.

    Best Regards,


    Bruce Song [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Bruce Song Wednesday, March 23, 2011 10:09 AM
    Friday, March 11, 2011 9:07 AM