Organizing data so its easy to get.

[SeaHag]

My problem is retrieving data from a database.

I really don't know all the available otions to me.

So i created a Access database to just function as a storage device.

I know the are better ways to organize data so it is easily accessed..

Does anyone Know where I should start..

Here is samlpe code of me accessing access..

Public Sub GetElectricsCosts()
Dim rstElect As Recordset ' record set variable
Dim i As Integer
Set DbsVacublast = OpenDatabase(PATH) 'setting database object var
Set rstElect = DbsVacublast.OpenRecordset("ElectPanel")
    rstElect.Index = "PrimaryKey"
   
    rstElect.Seek "=", m_floorConfiguration
    
        For i = 0 To 2
                  m_ElectCost(i) = rstElect(i + 1)
        Next i
        
    rstElect.Close
    DbsVacublast.Close
End Sub