Search results

  1. R

    INSERT INTO - Error 3073

    Yes, with DoEvents it works better and without freezing, but problems still persist. Today it chrashed after 28k of inserts... Its better, but not good.
  2. R

    INSERT INTO - Error 3073

    mdlueck:I tried it, but it still not works. Sometimes it fail after execute of 6000 inserts, sometime it fail after execute 2000 inserts... Then I tried to use querydef.execute sql, but it chrashed too, but not so often. Sometimes it crashed after 6000 inserts, sometime it crashed after 50k...
  3. R

    INSERT INTO - Error 3073

    Khalid: I have try it in Access 2010 and 2007 too, but result is same. Maybe in Access 2007, this problem appears not so often. Another interesting thing is: i have another import function, in this function i have to transform some fields, i have more columns, ... but it works faster and...
  4. R

    INSERT INTO - Error 3073

    Hi all. (For first i have to say, that my english is bad, so sorry ... :-) ) I have this special problem. In VBA i have function, that is inserting new records to the table. sql = "INSERT INTO ...VALUES... " - its basic INSERT INTO, nothing more CurrentDb.Execute sql I fill the sql...
Back
Top Bottom