Multi-user access to CintaNotes database

cinta67
Posts: 2
Joined: Thu Oct 01, 2015 4:11 pm
Contact:

Multi-user access to CintaNotes database

Postby cinta67 » Thu Oct 01, 2015 4:27 pm

OS: Windows 7 64-bit (latest updates)
Version: 2.9.3 (2015-07-27)

We have a shared network drive (running on Windows Small Business Server 2011) between multiple Windows 7 desktop machines. Our CintaNotes database is saved on this shared network drive.

Previously, each Windows 7 machine ran CintaNotes and could access and edit this database simultaneously. However, since updating each program to CintaNotes 2.9.3 - and automatically the database to Notebook format version 2904 too - Windows is locking the database to the first user to start CintaNotes, thus preventing other users from opening/editing it.

The exact message we get is:
"The Notebook file '[file location on mapped network drive]'
is used by another application and cannot be opened."

I can email or paste a copy of the log if you'd like. Thanks :)
User avatar
CintaNotes Developer
Site Admin
Posts: 4747
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Multi-user access to CintaNotes database

Postby CintaNotes Developer » Fri Oct 02, 2015 12:51 pm

Hi cinta67,

thanks for the quiestion!
There's an easy solution: in cintanotes.settings, set sqlite.pragma.locking_mode to NORMAL (on all clients!)
Alex
cinta67
Posts: 2
Joined: Thu Oct 01, 2015 4:11 pm
Contact:

Re: Multi-user access to CintaNotes database

Postby cinta67 » Mon Oct 05, 2015 4:38 pm

Your simple solution fixed our issues.

Thanks Alex :)
User avatar
CintaNotes Developer
Site Admin
Posts: 4747
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Multi-user access to CintaNotes database

Postby CintaNotes Developer » Wed Oct 07, 2015 8:55 am

You're welcome!
Alex

Return to “Bug Reports”