
August 11th, 2003, 08:43 AM
|
|
Junior Member
|
|
Join Date: Aug 2003
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Error Message when updating DB
I've set up a database in Access and I am able to extract the data into an XML document. Having done this I am then trying to populate another Access database with the data. When trying to do this the data is entered into the new database however when it reaches record 390 an error message is displayed on the command line saying the following:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Cannot open any
more tables.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown
Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate
(Unknown Source)
Altogether there are 519 records that I need to transfer so this is
causing me a few problems. Could anyone suggest why this is happening
and what I can do to stop it. Many thanks
James
|