OLD vs NEW Database Techniques in VB

See more:

VB

MS-Access

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)

'CREATE A DATABASE OBJECT
Global DatabaseDB As Database

'CREATE A WORKSPACE OBJECT
Global DatabaseWS As Workspace

'CREATE A RECORD SET FOR A TABLE IN THE DATABASE
Global DatabaseTable As Recordset

'OPEN THE DATABASE
Set DatabaseWS = DBEngine.Workspaces(0)
Set DatabaseDB = DatabaseWS.OpenDatabase(NameOfDatabase)

'OPEN A DATABASE TABLE
Set DatabaseTable = DatabaseDB.OpenRecordset("DatabaseTableName", dbOpenTable)

'SELECTING AN INDEX TO USE WHEN ACCESSING A DATABASE TABLE
DatabaseTable.Index = "SomeIndexDefinedInAccess"

'NAVIGATING THROUGH A DATABASE TABLE
DatabaseTable.MoveFirst   'positions at first record in table based on current index
DatabaseTable.MoveNext   'moves pointer to next record in table based on current index

'ADDING A NEW RECORD TO THE DATABASE TABLE
DatabaseTable.AddNew
DatabaseTable("LastName") = "Smith"
DatabaseTable.Update

etc. etc. etc.