All: I've got a Servlet using a JDBC-ODBC bridge to get at an Access database. The Servlet is able to retrieve the data just fine. We're in the situation where the Access mdb file is sent to us weekly so we will need to drop the file in to replace the old file every week. It appears that some component in the solution is keeping a lock on the file. If I shut down JRun, the lock goes away and we're able to replace the file. We've looked extensively at the code and we're closing all of our connections with each call to the servlet so no corrections remain established between servlet calls. I'm not sure if the bridge is keeping a lock on the file or not. When we try to replace the file, we get an access sharing violation. We can't really shutdown our JRun server weekly to replace this file. I know this is a little off topic so if anyone has seen this behavior or has some suggestions, please respond off-line. Thanks, Brian ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
