none
Driver ODBC Microsoft Access] Impossibile aprire altre tabelle.

    Question

  • sul pc (xp con un processore vecchio elento) dell'ufficio eseguo senza errori il progetto java lanciato con eclipse, invece sul pc di casa (w7 64 con processore i7) l'esecuzione dura un decimo ma non carica tutte le righe in tabella scartandone alcune con il seguente errore

    il programma legge un file xml e carica i dati in access suddivinendolo in 7 tabelle.

    percentualmente solo 2 sono interessate quasi per il 90% delle righe.  

    Driver ODBC Microsoft Access] Impossibile aprire altre tabelle.

    Non riesco a trovare dove si deve configurare qualcosa che elimini l problema

    Il progetto ed anche eclipse così come il db access è su un disco esterno per cui si lancia proprio fisicamnete lo stesso eseguibile e si trattano gli stessi dati sullo stesso db access 2007

    Grazie

    Dopo alcune prove posso aggiungere che ;

    1) le righe non inserite nelle tabelle di access 2007 non sono sempre le stesse

    2) se rallento le operazioni per esempiomettendo sottotrace il driver gli errori diminuiscono in generale, scompaiono completamente per le tabelle con meno inserimenti

    3) i vodici errore sono -1311 s1001

    4)gli errori sono solo tra le prime 10.000 righe

    5) se isolo il gruppo contenente alcuni scarti lo carica tranquillamente

    6) se invece prendo un gruppo + consistente come le prime 2000 righe ancora segnala gli errori

    ne deduco che ci deve essere qualche cosa da configurare tipo buffer pool o simile o nel driver o su access

    Qualcuno ha avuo esperienze simili?

    Grazie



    • Edited by old_atanor Friday, August 10, 2012 2:11 PM
    • Moved by Forrest Guo Sunday, August 12, 2012 3:18 PM language does not support (From:Developing Apps for Office)
    Thursday, August 09, 2012 3:33 PM

Answers

  • I'd be somewhat concerned about the speed and shear number of iterations and the delicacy of the access jet db engine. If you're going to stay with access backend you might ask them here about what you're doing.

     http://answers.microsoft.com/en-us/office/forum/office_2007-access

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by old_atanor Monday, August 20, 2012 10:59 AM
    Wednesday, August 15, 2012 12:39 AM
    Moderator

All replies

  • Sorry, we're not able to support in Italian.  You're welcome to ask the question in English.

    thanks.


    Forrest Guo | MSDN Community Support | Feedback to manager

    Sunday, August 12, 2012 3:18 PM
  • I developed a little project with java on office  pc (XP with a slow and old processor ) and everything works flawlessly.

    I launched the project with eclipse, the project reads an xml file and loads the data into different tables in Access 2007, running time is 68 minutes

    Then I took the external drive at home and I run the same project on my home PC (64 w7 i7 processor) running time is 12 minutes but discards some lines with the following error

    Driver ODBC Microsoft Access] Impossibile aprire altre tabelle (Could not open any more tables)

    The program reads an xml file and loads the data in seven Table.

    the two PCs have the same version of java eclipse and access

    2 tables load 90% of the lines (about 280 000 rows each).

    1) the discarded lines are not always the same

    2) if I slow down operations such as putting a trace driver, errors in general decrease, disappearing completely for tables with fewer entries

    3) error codes are -1311 s1001

    4) the errors are only one of the first 10,000 rows

    5) If I isolate the group containing the waste, these lines are loaded correctly

    6) if instead I take a group like the first 2000 lines still reports errors

    I conclude that there must be something to set buffer pool or the like or the driver or access


    Someone avuo similar experiences?

    Thanks


    • Edited by old_atanor Sunday, August 12, 2012 4:46 PM
    Sunday, August 12, 2012 4:45 PM
  • Might ask them in a java programming forum. From your description I'm guessing you're running up against some limit for access objects. Running a faster processor the connection object may not have time to close them.

    http://blogs.office.com/b/microsoft-access/archive/2006/06/05/access-2007-limits.aspx

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Proposed as answer by Forrest Guo Monday, August 13, 2012 12:56 AM
    Sunday, August 12, 2012 8:57 PM
    Moderator
  • Thankyoufor the suggestion

    I use tables are 7
    1) months (12 items)
    2) days (365 items)
    3) hours (12 items per day)
    4) the schedule of events (1 event every six seconds for a period of 3 days(date time sensor and watts))
    the other 3 are the counters then contain the numbers of total
    Everything, therefore well below the limits of the database

    I did another test on another pc (w7 i5 processor) the result is that discards fewer elements, and totally different
    I found how to configure the buffers the driver treads.
    changing values​​, changing also the errors but do not disappear

    I'll try to post on the forum java

    in the meantime I have downloaded mysql

    thanks

    Tuesday, August 14, 2012 11:15 PM
  • I'd be somewhat concerned about the speed and shear number of iterations and the delicacy of the access jet db engine. If you're going to stay with access backend you might ask them here about what you're doing.

     http://answers.microsoft.com/en-us/office/forum/office_2007-access

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by old_atanor Monday, August 20, 2012 10:59 AM
    Wednesday, August 15, 2012 12:39 AM
    Moderator