benlinkknilneb
Programmer
Can someone please give a simple example of how to open a "recordset" from Access2000 with VB.net? I've been through hundreds of posts on here, and through page after page of the Books Online... I understand that something has changed from VB6, but nowhere do I find a good explanation for what to do now.
All I want is this:
I have an Access2000 mdb with several tables, which my VB6 app was querying and returning results from.
I'd like to know how to:
a) open a table (and/or the results of a query) so that i can manually read each record (in vb6 i'd use the .movenext)
b) open "querydef" objects (are they still called that?) and change the SQL statements inside them
Anybody that can shed some light on this for me, thanks in advance!
Ben
All I want is this:
I have an Access2000 mdb with several tables, which my VB6 app was querying and returning results from.
I'd like to know how to:
a) open a table (and/or the results of a query) so that i can manually read each record (in vb6 i'd use the .movenext)
b) open "querydef" objects (are they still called that?) and change the SQL statements inside them
Anybody that can shed some light on this for me, thanks in advance!
Ben