http://jackcess.sourceforge.net/
Brandon Goodin
On 7/29/06, AlexeyG <[EMAIL PROTECTED]> wrote:
Thanks for your responses!
MS Access is used only for data import... admin uploads the MS Access DB
and I import records. Successfully imported records get deleted, failed
records remain. Admin can then download the DB back and fix failed records.
I need that lock released so that I can "compact" the Access DB by launching
"access.exe *db path* /compact... Without compacting the Access DB remains
the same size even if all but few records are deleted... It is a bit of a
pain, but I'm pretty much stuck with that process.. At least I do not have
to deal with tables to store failed import data, or write an interface to
allow admin to fix it.
Sounds like getting a good driver or using JDBC straight up and releasing
connections is the way to go... Thanks!
--
View this message in context: http://www.nabble.com/MS-Access-LDB-locks-using-JDBC-ODBC-bridge-and-iBATIS-tf2017245.html#a5558867
Sent from the iBATIS - User - Java forum at Nabble.com.
