[GNC] Problems Accessing GnuCash Files on my D:\

[brob2684]

Hi Colin and David

Thanks very much for your replies.


Colin Law wrote
> Are you using File > Open to open the file?  If so are you able to
> browse the folders on D: ok and see all the files there?

It makes no difference whether I double click on the file, or go file open.


If you copy the file that you can't open from D: to a different drive
are you able to open it from there?


Yes, if I copy the file off the D: drive to my backup drive, I can open it
there. No need to change permissions, or anything, it just works. The
problem seems to be restricted to my D:.


What happens if you open the file from the backup folder and then use
File > Save As to save it to D:?


I get the following message if I try to save the database in XML format as a
new file:
    Gnucash could not obtain the lock file for
D:\Documents\<name>\Data\GnuCash\Balsheet-new.gnucash. That database may be
in
use by another user, in which case you should not save the database. Do you
want to proceed with saving the database?
    Selecting "Save" results in no file being saved. 

And if I try to save the database in sqlite3 format, I get the following
message:
    Can't parse the URL
D:\Documents\<name>\Data\GnuCash\Balsheet-new.gnucash
Again, no file is saved.

If I try to save the file as an XML file overwriting an existing file in the
directory, I get the following message:
    Could not make a backup of the file
D:\Documents\<name>\Data\GnuCash\Balsheet.gnucash

If I try to save the file as a sqlite3 file overwriting an existing file in
the directory, I get the following message:
    The server at URL D:\Documents\<name>\Data\GnuCash\Balsheet.gnucash
experienced an error or encountered bad or corrupt data.

I am no longer getting the lock error message this morning when attempting
to overwrite. I did this step before attempting to open a file on my D:, so
as David Carlson suggested, it is quite likely I may have had a copy of the
original file open yesterday when I was trying to save as and overwrite it.


If you try to open something like a .doc file from the same folder on
D: in Word or whatever you use is that ok?  Are you able to save it
again.  That may tell you if it is a system problem rather than a
GnuCash problem.


As I said in my initial message, I have no problems saving to the same
directory from Microsoft Word. Also, being explicit this time round, I can
open, edit and save the same file in Word without issue.


When you get the " Gnucash could not obtain the lock file for..." message,
it appears that you actually have the copy on your D: drive open rather
than your backup.  Have you checked the file dates of each copy and the
most recent Gnucash backups (with the .2019xxxx.gnucash suffix in the
name)  in each location?

It's quite possible a version I had attempted to open may have been open in
the background yesterday as I am no longer receiving that specific error
message this morning after rebooting my PC. However, as shown by the saving
tests I conducted for Colin above, I still cannot save to the D: location.
Nor can I open a guncash file from that location without error.


What version of GnuCash are you using, what version of Windows are you
using, and how is your drive D: connected to your computer?  When you tried
editing a document on your D: drive per Colin's suggestion, did that work?
How do you address your backup and how is it connected?  How and when do
you back up your D; drive? Have you been diligent about updating Windows OS
and the OS on your D: server?


GnuCash 3.4 from December 2018. This hasn't changed in the past two weeks
(it was installed back in January). I have uninstalled and reinstalled
GnuCash to no avail.

My primary hard drive is split into two partitions, the C: where Windows
resides and the D: where I save my data. The My Documents folder has been
moved to the D:, but it's been this way since the computer was set up, so
again this hasn't changed. GnuCash has no issues saving or opening a file to
C:\Users\<name>.

The backup question was a good one. I have two backups - one saved to a WD
MyBook Elite drive that is directly connected to the PC and accessed via the
L: (I have no idea why Windows gave it that letter, I do not have that many
drives). The files saved here have no issues. The WD backup software hasn't
been updated in years (but it's the latest version on issue). This backup
has not changed.

My NAS also takes a backup of the D: periodically and saves it in read-only
format. I am experiencing the same access errors here. However, I must admit
I have never before tried to open a GnuCash backup file off the NAS. Copying
this file to my WD Backup and unticking the read-only flag sees GnuCash
again work correctly. As far as I can tell, the NAS hasn't been updated
recently - it tends to run and not give me any grief so it's been left
alone. 

Windows 10 updates get downloaded and installed automatically. The Windows
version is 1809 and the OS build is 17763.316 (no idea what the difference
between the two numbers is).

Thanks for the suggestions so far. I don't mind if I can't directly access
the files from my NAS, but I am perplexed as to why GnuCash won't read/write
from my D:.

Thanks again,
brob2684



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html