Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #3119

Re: Container Problem: File Cannot be Found

Show all headers | View raw

On 2018-04-03 00:41:48 +0000, Charles H. Sampson said:
> 
> I'm creating a largish database that contains pointers to music files
> (.aif) in containers. The database has reached over 1000 records in the
> that use the containers. I've just noticed that over 500 of them now
> display the message "The file cannot be found". I got this message once
> before when I changed the name of the disc the files are located on.
> (They're all on the same disk.) I managed to fix it then, but I don't
> remember how. In any case, there have been no new disk name changes.
> 
> Any ideas? In previous posts, the feeling was that containers are a
> mess.
> 
> Charlie

Disk name changes, folder name changes, filename changes, files being 
moved or deleted, an external drive not being mounted, copying files 
from one user account to another, failing drive, etc. ... there are 
MANY MANY possible causes for a "file not found" error.

If it's not as simple as plugging an external drive back in and 
re-opening the database, then the only potential way to fix it, if it's 
possible to set the stored filepath (I vaguely remember reading about 
extracting the filepath from a Container field's link), MIGHT be to use 
a Script and/or the Replace command with Calculation to fix the stored 
links with the correct name, assuming you know what the correction has 
to be and it is the same fix across all (or at least groups of) linked 
files.

Otherwise, you would have to go back and re-insert all the files individually.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-02 17:41 -0700
  Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-03 13:36 +1200
    Re: Container Problem: File Cannot be Found ursus.kirk@gmail.com - 2018-04-03 10:09 +0200
  Re: Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-09 09:23 -0700
    Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-10 09:40 +1200
      Re: Container Problem: File Cannot be Found csampson@inetworld.net (Charles H. Sampson) - 2018-04-14 11:59 -0700
        Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-15 10:07 +1200
          Re: Container Problem: File Cannot be Found Erik Appeldoorn <ursus.kirk@gmail.com> - 2018-04-15 08:25 +0200
            Re: Container Problem: File Cannot be Found Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-04-15 19:24 +1200

csiph-web