I have seen this problem extensively with certain combinations of the jdbc dbc bridge and MSAccess. Stop pulling your hair out, there are 2 workarounds to force this last record to insert: 1) Close the connection each time afterwards. 2) Do a dummy select each time afterwards. That seems to be the better one. That means: after your last insert (not after each record) do this "trick".(after "insert into emp..." execute a query "select something from emp...) Not sure if the select has to be from the same table as the insert, but you can try it both ways Jamie
Joined: Mar 25, 2001
It's very strange now no problem at all. If I encountered this problem again, I'll do like what you said.