Inserting multiple records into Access in web app.

Have a problemwriting to an Access database while looping through an array to read input data.

Everything works fine for a single record - but when there are several sets of data that need to written to multiple records in same table - booom! get type mismatch error and page crashes.

Wondering if Access can't lock and unlock records fast enough to keep process moving.

Any thoughts or ideas very welcome.

Thanks in advance.

Richard Sampson
Construction Communicator

www.rsai2.com