On Sun, Sep 16, 2007 at 08:42:44PM -0700, Joe Wilson wrote: > Host a shared database file on computer A, say shared.db. > >From computer B, open shared.db remotely and execute "BEGIN EXCLUSIVE;". > >From computer C, open shared.db remotely and execute "BEGIN EXCLUSIVE;". > If computer C has the error "SQL error: database is locked", then > its locking probably works.
BTW: I'm wondering, if there's a possibility to set in similar manner exclusive rights to access the database file for the duration of the entire "database session", not just transaction. I mean: when I'm using a program which is accessing the database - nobody else has access. -- pozdrawiam / regards Zbigniew Baniewski ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------