Data access in VB6 equivalent in VB2005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ZackSnr
    New Member
    • Feb 2007
    • 2

    #1

    Data access in VB6 equivalent in VB2005

    I am in the process of moving from VB6 to VB2005.
    I need some help with methods that I frequently use in my apps and are struggling to find the equivalent process and more sepcifically code examples with correct syntax for VB2005.
    The basic stuff, creating input forms using designer is easy enough.
    I need to open a database (Access 2000), then open 2 tables, then loop through table 1, using a value in row1 column 2 and then search for that value in table 2. I then want to insert/edit a value in column X in table 1 and update(save) the changes. Either one by one or batch update at the end. Whatever method is more efficient.
    I then want to move to the next row in table 1 and repeat the process.
    regards
  • sashi
    Recognized Expert Top Contributor
    • Jun 2006
    • 1749

    #2
    Originally posted by ZackSnr
    I am in the process of moving from VB6 to VB2005.
    I need some help with methods that I frequently use in my apps and are struggling to find the equivalent process and more sepcifically code examples with correct syntax for VB2005.
    The basic stuff, creating input forms using designer is easy enough.
    I need to open a database (Access 2000), then open 2 tables, then loop through table 1, using a value in row1 column 2 and then search for that value in table 2. I then want to insert/edit a value in column X in table 1 and update(save) the changes. Either one by one or batch update at the end. Whatever method is more efficient.
    I then want to move to the next row in table 1 and repeat the process.
    regards
    Hi there,

    Show us your code segment, will try to debug your code. Take care.

    Comment

    Working...