Data access in VB6 equivalent in VB2005

[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

[sashi]

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.