Sharing Database - Windows/XP

[M Prindle]

Are you accessing the directory through a mapped network drive or
through a UNC path?  I know some apps behave strange when using a UNC
path ( example \\DELL\GNUCash\database )

Mike

On Wed, Apr 21, 2010 at 2:28 PM, Phillip Richcreek
<pwrichcreek at gmail.com> wrote:
> Mike,
>> ...Does the share directory have full read/write/create permissions on it?
>
> Yes.
>
> For simplicity's sake, let's call the computer where the gnucash
> database resides "DELL" and let's call the other computer "HP". HP is
> the computer that is having the problem opening the database. I ran a
> test using a text editor on computer HP and demonstrated that the
> editor could indeed write a new file to the gnucash directory -- the
> shared directory where the gnucash database resides.
>
> I'm able to see the lock file, account database.LCK, from both DELL
> and HP, when I have the database open on DELL. After I close the
> database on DELL, I see that the LCK file is no longer present and I
> can see that from both DELL and HP by listing the files in the
> directory. Nevertheless, when I start gnucash from HP, even though no
> other instance of gnucash is running on DELL, I get the unable to
> obtain the lock message and the program opens the database for
> read-only.
>
> It would appear the gnucash is doing something more than just looking
> for the presence of the LCK file to determine whether another instance
> of gnucash has the database open for write.
>
> Phil
>
> On Wed, Apr 21, 2010 at 2:13 PM, M Prindle <mprindle at pobox.com> wrote:
>> Oh yes that is what I thought you ment.  When GNUCash lauches and you
>> open the database it creates a lock file in the database directory.
>> If for some reason the network client don't have the privs to create
>> the file you could get that error.  Does the share directory have full
>> read/write/create permissions on it?
>>
>> On Wed, Apr 21, 2010 at 1:03 PM, Phillip Richcreek
>> <pwrichcreek at gmail.com> wrote:
>>> Mike,
>>>
>>> Thanks for your reply.
>>>
>>>>  One one person can have the database open at at time.
>>> In retrospect, I can see that my original message implied that I want
>>> to have the database open for read/write by two users at the same
>>> time. I don't expect that. But I do want either user/computer to be
>>> capable of writing to the database, provided no other user has it open
>>> for write access at the same time.
>>>
>>> I failed to state that, when I received the gnucash unable to obtain
>>> the lock message, no other user had the database open -- neither for
>>> read-only nor for write. That's what makes me suspect that it's
>>> something in my Windows configuration that is causing the problem.
>>>
>>> I hope someone who is doing what I'm trying to do can help me
>>> understand where I'm going wrong with my Windows sharing settings.
>>>
>>> Phil
>>>
>>>
>>> On Wed, Apr 21, 2010 at 1:39 PM, M Prindle <mprindle at pobox.com> wrote:
>>>
>>>> GNUCash is a single user system only and it's not dependent on the OS.
>>>>  One one person can have the database open at at time.  Both computers
>>>> can access the database, but separately.  As far as I know there is no
>>>> way around this currently.  The message unable to obtain lock is
>>>> GNUCash's way of protecting the database while it's open.
>>>>
>>>> Mike
>>>>
>>>>
>>>>
>>>> On Wed, Apr 21, 2010 at 12:08 PM, Phillip Richcreek
>>>> <pwrichcreek at gmail.com> wrote:
>>>>> I want to access  gnucash accounts from two computers, with both
>>>>> having read/write access. When I open the database I get message
>>>>> "gnucash could not obtain the lock for \\Dell-8250-den\network shared
>>>>> files\GnuCash\Account Database". I choose the option to "open the
>>>>> database for read only" and the accounts show up as expected -- so I
>>>>> know I'm able to access the desired file, but apparently for
>>>>> read-only.
>>>>>
>>>>> I suspect that this is a Windows issue, but I wonder if anyone
>>>>> subscribed here has experience with this configuration and if so, can
>>>>> help me understand what I need to change in my Windows sharing setup?
>>>>> I'm running Windows/XP SP3 with all patches up to date.
>>>>>
>>>>> TIA,
>>>>>
>>>>> Phil
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>>
>>>>
>>>
>>
>