New answers tagged

5

The cause of this problem most likely is the primary key of the table in DB2. Access can not handle some data types as primary keys well. Notoriously bad for PKs are all floating point numeric types. They may be rounded differently on the server and in Access. If Access uses a floating point value to query a single record from the server, there will be no ...


1

Just batch it up into values (1,1), (2,2) .... There is going to be a sweet spot but anywhere from 100 to 10,000 values in a batch A producer consumer is good here where you have multiple producers watching directories and then one consumer writing to the database. I do exactly this were I am parsing down some files for words and load them into a ...



Top 50 recent answers are included