can i use jdbc driver other than type 1 for MS-ACCESS

Can you avoid locking issues: use lowest transaction isolation?

Do you have several indexes on the target table?

Try to switch them off while copying (drop and re-create afterwards).

Another idea:

why should you hold such big rows redundantly?

Has it to be a different table, or can it be done with a 1-char field containing mode or state or such a thing, representing the same information as if the row was in another table?

Hartmut at 2007-7-1 16:14:13 >