about ADO

hi , iam ADO new user , i want to ask about a problem i face , first when i want to make a connection i use this:

Dim DB As New ADODB.Connection
Dim DBT As New ADODB.Recordset
   
DB.Open "DSN=MS Access Database; DBQ=C:\TestDB\Access.mdb;DefaultDir=C:\TestDB; " _
         & "DriverId=281;FIL=MS Access; MaxBufferSize=2048; PageTimeout=5;UID=admin;"
   
DBT.Open "test_spe", DB, adOpenDynamic, , adCmdTable


and this works but when i want to make a search i tried to use the index an seek but i found that the index and seek methods not supported as i found by using:

DBT.Supports(adIndex) & "   " and DBT.Supports(adSeek)

so i used find method but i found that it is very slow comparing to seek

another problem : i cannot use addnew and update to add records so i used insert into

is there a problem with my code and why index \ seek and addnew \ update not work ?