Hi Fernand, > - When after redoing my coding homework , a connection is still left > "open" due to a usermachine who chrashes.... how can i close "all > conections" ? instead of sending a mail to the users and asking to > restart OO :-)
In this case, we need to talk about the definition of "locked" :) If there is a .lck file besides the .odb file, this doesn't mean the database is "locked" in a file system sense. Instead, it just means that either somebody has an open connection to this database, or the last instance which had an open connection did not shutdown properly. HSQLDB, the engine used in Base, is able to cope with the latter case automatically. That is, upon next connection, it will recognize that the previous connection did not properly shut down, and recover the database. However, I now seem to understand that you're trying to access a shared .odb file, with embedded HSQLDB, simultaneously with multiple users. Is this correct? If so, then your "locked" probably means that the second user cannot connect to the .odb file at all. This is since Base with embedded HSQL currently simply does not support this scenario at all. Such databases are strictly single-user at the moment. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
