Container field points to network...

[swpowe]

I'm trying to create a database for some sound effects and I'm running into problems with the network aspect. I've got some sound effects on a network share and I've got my container fiedls with a reference to those files and everything works on my machine but if I open the database on another machine on the network it doesn't play the files...the link is broken. How can I view the link or change the link of a container field? is it even possible to do this? I can't store the files in the database for a couple reasons but one of which is it would be huge. thanks for the help!

[CobaltSky]

a container field? is it even possible to do this? I can't store the files in the database for a couple reasons but one of which is it would be huge. thanks for the help!

If you're going to use the straightforward method via the "store file as reference" option when inserting the audio into container fields, then the only way it will work is if all of the machines are configured to "see" the network drive where the files are stored at the exact same path - and if all of them always have the share mounted while using the database.

If that's not feasible, then an alternative would be to store relative paths (to eacg sound file on the shared drive) as text in a text field, then set up a preferences table in which each machine's path to the network share is stored. With this, you'll be able to create a calculating container field for which the calculation resolves to the correct path to the file on the network share (for the current user, based on the prefs table and the stored text path info). The paths produced by the calc will be required to be in a format such as:

   moviewin://serverName/shareName/directoryName/fileName.mp3