Questions about using ADO Recordsets in VB.NET vs VBA
Posted on 2016-07-28
I read in the "Microsoft Access Guide to SQL Server" book the following: "Code in Access Class modules is very portable to Visual Basic. This means that a middle tier data-access class can be prototyped and tested using Access and then ported to a Visual Basic ActiveX DLL project later."
However, I just tried writing code to open an ADO recordset in VB.net, and accessing the value of the fields using the "RS!Fieldname" syntax that works fine in VBA didn't work. Nor did the "RS("FieldName")" syntax. I had to use the syntax "RS.Fields("Fieldname").Value" syntax. Generally, is there a list of syntax that is VBA specific and syntax that will work in both VBA and VB.NET? I want to use syntax that will work with both so I won't have to change as much when it comes time to convert from Access class modules to VB.net classes?
Also, I read in a Microsoft on-line document "to make the RecordSet fully usable within a .NET application, convert it to an ADO.NET DataSet by using the OleDbDataAdapter class". What more can you do with a dataset in a .NET application that you can't do with an ADO recordset?