Hi

I have developed an Excel Application using mdb file as database.
The problem is, if there is any possibility to update data in database by update statement eg. Update Tabela Set sth=5 where id=5; ?

Because now I have sth like this:

Set baza = OpenDatabase(c:\database.mdb)
Set tabela = baza.OpenRecordset("Tabela", dbOpenDynaset)

Do
With tabela
.MoveFirst
If !ID = 5 Then
.Delete
.AddNew
!ID = 5
!sth = 5
.Update
Exit Do
Else
.MoveNext
End If
End With
Loop

and it take to much time to update all data.
I'm new in database issues in Excel, so I really apreciate any help.

Thanks in advance,

£ukasz ¯ebrowski