The connection type does not matter. However, if you are not using the
native Jet OLEDB provider, I suggest you do so. See
www.able-consulting.com/ado_conn.htm for examples.
You are falling victim to a performance enhancement in Jet: update-caching.
I'm a little surprised about this as you are not using a cursor to do your
insert. However, see these KB articles:
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the