Have all connections/resultsets been closed? Hanging connections/resultsets cause updates to be delayed in Access. Regards, Reuben.
Originally posted by kevin quinn: I am running JSP on Tomcat, NT using a simple Access backend. Often, users will be told they have made a successfull insert into the database but the database was not updated. Any Ideas?
I have heard of this happening from other people using access. You have to close the connection(can be time consuming to open/close connections after every SQL statement) OR do a meaningless select from the table you updated. For somereason when you do a query on the table you just updated, the changes mysteriously show up! eg. "insert into emp values (id,...)" after this insert perform a select on emp- "select id from emp where id = 'somevalue'" hope this helps, Jamie