I'd like to work with data of a table by VBA code not by MS Access interface. There is another way to do it, than to use this:

Public Sub MySub()
...
DoCmd.Opentable MyTable
...
End Sub

Am I right? Please, advise what code is the best for this?