Good day all.
In the early to mid-90's I wrote many programs for local businesses using BTRIEVE (anyone remember that?) and Microsoft Quick Basic. Then I moved my environment to Visual Basic using Access as my preferred method of database storage. As it turned out, the primitives used in BTRIEVE to create a database, access records, update records, etc. were extremely similar to those I needed to use in the VB/Access environment.
I am aware of the "accepted" methods for database usage with VB.net programs. However, I've never seen any references or documentation for doing it using my "old fashioned" methods. As an example of what I'm referring to, I have included some sample statements below that are from a VB6 program that manages data in an Access database.
I'm not trying to initiate a debate regarding the merits of different databases, languages, etc. Just asking a simple question, which is: Does VB.net support these "old fashioned" database manipulation methods, specifically as it pertains to ACCESS as the database?
Thank you in advance for your thoughtful and informative considerations.
(Sample code from VB/Access program)
Global DatabaseDB As Database
Global DatabaseWS As Workspace
Global DatabaseTable As Recordset
Set DatabaseWS = DBEngine.Workspaces(0)
Set DatabaseDB = DatabaseWS.OpenDatabase(NameOfDatabase)
Set DatabaseTable = DatabaseDB.OpenRecordset("DatabaseTableName", dbOpenTable)
DatabaseTable.Index = "SomeIndexDefinedInAccess"
DatabaseTable.MoveFirst
DatabaseTable.MoveNext
DatabaseTable.AddNew
DatabaseTable("LastName") = "Smith"
DatabaseTable.Update
etc. etc. etc.