Playing WAV files over a network using Access 2k app?

Hi Folks,

I have an Access 2k app that is often run on a LAN with several users.
Unfortunately there is one feature that fails to work in that setup.

Our app allows the user to play WAV audio files through their sound
card that is connected to their phone through a proprietary piece of
hardware. This feature works fine on the machine that hosts the back
end data base. It does NOT work for a client PC because, for whatever
reason, WAV files with pathnames stored on the host PC's back end
table will not play across the network.

I wrote a procedure that allows the client PCs to copy the WAV files
and their link table to a local XLS file. I then tried linking the
that file as a table stored in the Front End MDE data base. It STILL
does not work.

Anyone have a clue what I'm missing?

Thanks.

re: Playing WAV files over a network using Access 2k app?

Lauren Wilson <???@???.???> wrote in message news:<9fien050dv5j30eo2o7n7ajo4d52gjkbpb@4ax.com>. ..[color=blue]
> Hi Folks,
>
> I have an Access 2k app that is often run on a LAN with several users.
> Unfortunately there is one feature that fails to work in that setup.
>
> Our app allows the user to play WAV audio files through their sound
> card that is connected to their phone through a proprietary piece of
> hardware. This feature works fine on the machine that hosts the back
> end data base. It does NOT work for a client PC because, for whatever
> reason, WAV files with pathnames stored on the host PC's back end
> table will not play across the network.
>
> I wrote a procedure that allows the client PCs to copy the WAV files
> and their link table to a local XLS file. I then tried linking the
> that file as a table stored in the Front End MDE data base. It STILL
> does not work.
>
> Anyone have a clue what I'm missing?[/color]

No, but what if you create a subdirectory where you file sits and put
the files in there on the local machine(s). Do a Dir() to find out if
the file exists, and if not, copy it. then run it locally. Other
than that, not a clue.

re: Playing WAV files over a network using Access 2k app?

On 21 Oct 2004 06:08:45 -0700, pietlinden@hotmail.com (Pieter Linden)
wrote:
[color=blue]
>Lauren Wilson <???@???.???> wrote in message news:<9fien050dv5j30eo2o7n7ajo4d52gjkbpb@4ax.com>. ..[color=green]
>> Hi Folks,
>>
>> I have an Access 2k app that is often run on a LAN with several users.
>> Unfortunately there is one feature that fails to work in that setup.
>>
>> Our app allows the user to play WAV audio files through their sound
>> card that is connected to their phone through a proprietary piece of
>> hardware. This feature works fine on the machine that hosts the back
>> end data base. It does NOT work for a client PC because, for whatever
>> reason, WAV files with pathnames stored on the host PC's back end
>> table will not play across the network.
>>
>> I wrote a procedure that allows the client PCs to copy the WAV files
>> and their link table to a local XLS file. I then tried linking the
>> that file as a table stored in the Front End MDE data base. It STILL
>> does not work.
>>
>> Anyone have a clue what I'm missing?[/color]
>
>No, but what if you create a subdirectory where you file sits and put
>the files in there on the local machine(s). Do a Dir() to find out if
>the file exists, and if not, copy it. then run it locally. Other
>than that, not a clue.[/color]

Thanks Peter. We figured it out. What you suggest plays a central
role in the solution.

re: Playing WAV files over a network using Access 2k app?

> Thanks Peter. We figured it out. What you suggest plays a central[color=blue]
> role in the solution.[/color]

And the answer was?

re: Playing WAV files over a network using Access 2k app?

On 22 Oct 2004 04:48:33 -0700, pietlinden@hotmail.com (Pieter Linden)
wrote:
[color=blue][color=green]
>> Thanks Peter. We figured it out. What you suggest plays a central
>> role in the solution.[/color]
>
>And the answer was?[/color]

I'm embarrassed to admit that the solution was so simple. I did not
see it because I was trying to make the problem more complicated than
it was. All we had to do was to abandon trying to use UNC path names
and copy the wav files from a folder on the host to an identically
named folder on the client. That way, the non-UNC pathnames were
identical on all user machines.

I assume that the wav files would not play correctly via UNC path
references because of the time delay for network transport. Audio is
time/rate sensitive. I believe that music and other audio requires
streaming technology to play correctly over a network of ANY kind.
Please correct me if I am wrong.

re: Playing WAV files over a network using Access 2k app?

Lauren Wilson <???@???.???> wrote in message news:<aue8o05o7jenp8qlds7bdb23gdp06harjf@4ax.com>. ..[color=blue]
> On 22 Oct 2004 04:48:33 -0700, pietlinden@hotmail.com (Pieter Linden)
> wrote:
>[color=green][color=darkred]
> >> Thanks Peter. We figured it out. What you suggest plays a central
> >> role in the solution.[/color]
> >
> >And the answer was?[/color]
>
> I'm embarrassed to admit that the solution was so simple. I did not
> see it because I was trying to make the problem more complicated than
> it was. All we had to do was to abandon trying to use UNC path names
> and copy the wav files from a folder on the host to an identically
> named folder on the client. That way, the non-UNC pathnames were
> identical on all user machines.
>
> I assume that the wav files would not play correctly via UNC path
> references because of the time delay for network transport. Audio is
> time/rate sensitive. I believe that music and other audio requires
> streaming technology to play correctly over a network of ANY kind.
> Please correct me if I am wrong.[/color]

Oh, I have never ever made anything more complicated than it was.
Ever. Oh, I *wish*!!!