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)

With tabela
If !ID = 5 Then
!ID = 5
!sth = 5
Exit Do
End If
End With

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