this is the one thing i never even looked into in VB6, i've done some database work in PHP using MySQL but that's it
anyway, im trying to stumble through; i've found out how to create a DSN-less connection to the database (i think) with the following code:

Dim objDs As DataSet
Dim ObjDa As OleDbDataAdapter
Dim sSQL As String
sSQL = "SELECT * FROM Accounts"
objDs = New DataSet()
ObjDa = New OleDbDataAdapter(sSQL, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Environment.CurrentDirectory & "\db\database.mdb")


im just trying to figure out how to retreive the result of the SQL statement,

thanks for any assistance,