Hi,

I have a large ms access table and would like to add new record to it from an unbound form.

Currently this is the code:

set rst= currentdb.openrecordset ("table1")
rst.addnew
rst!id= myID
rst!name= myname
rst.update

Thing is that opening the record set is very slow (again a big table).

any ideas how to improve performance on this?

Thanks!