I have an asp page that updates an Access table based upon form input.

Typically, the update will include about 30 rows of data with about 7

fields per row.



Currently, I open a connection to the database and then start looping

through the form fields to create a SQL update statement. I then do an

objConn.Execute sqlSatement... I end up doing this for each record needing

updating.



Occasionally this updating crashes the web server.



I am looking for the most efficient/best way to do batch record updates in

Access.



-Should I do that batch update in a COM component?

- Should I uses a query and use parameters to update?



Thanks for the help.