• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access Insert - last row missing

 
Brendan Caden
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am creating two connections to two access databases and then copying the contents of a table in the source database to the empty destination database. It works fine but misses the last row of data. I can't see the problem - does access have to commit the last row?

The println prints out the missing row.
 
Brendan Caden
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found the answer in a previous post.

Access is rubbish use a proper database - no really - there is a bug that prevents the last row from being commited. As a workround add a query after the inserts and this causes the last row to commit.

Pants I know but true.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic