Access locks table after query

From: Ian deSouza (ian_desouza_at_yahoo.com)
Date: 03/25/04

  • Next message: Harri Pesonen: "Searching for a database to replace Access" 
    Date: 24 Mar 2004 15:49:42 -0800

    Hi.

    I'm using the jdbc-odbc bridge driver to MS Access. I'm using a
    PreparedStatement to do a select on a table.

    >From another process, a request to drop the table was issued, but its
    throwing the following:

    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could
    not lock table 'IanTable'; currently in use by user 'admin' on machine
    'xxxx'.

    I didn't do anything with autocommit (so its by default true). I made
    sure that after I get the data from the prepared statement's
    resultSet, I close the resultSet. I don't understand why the driver
    would lock the table after the select.

    This seems to happen only with Access.

    Anybody else have this problem? Any solutions?

    Thanks in advance, Ian

  • Next message: Harri Pesonen: "Searching for a database to replace Access"