Does any one know how (or if it's possibe) to upload a audio file (MP3 or RealAudio) into a access database?

Also is it then possible to create a dynamic link from the database to the audio file.

I'm currently making a web site for an online Record Store and I'm completely stuck so any help what so ever would be really helpful.

Thanks.

It's possible!
I've created my own Intranet with MP3 music and movies for Local use.
<img src="www.home.zonnet.nl/mooijaart/opslag_plaatjes/musicbase.jpg" border=0>

And in the Database i've put the Artist name with she song title.
And those 2 form a playlink that is in the database. The playlink in the DB is "file://2000server/mp3/Albums/Trance/Armin van Buuren/002 Basic Instinct/CD2/01 - Yahel - Sugar 1.mp3"

But be aware of a UNIX server that is Case sensitive and does not alow SPACES.

Good luck!
@WIN

Arrrh, I don't understand. Where should I start?


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
It's possible!
I've created my own Intranet with MP3 music and movies for Local use.
<img src="www.home.zonnet.nl/mooijaart/opslag_plaatjes/musicbase.jpg" border=0>

And in the Database i've put the Artist name with she song title.
And those 2 form a playlink that is in the database. The playlink in the DB is "file://2000server/mp3/Albums/Trance/Armin van Buuren/002 Basic Instinct/CD2/01 - Yahel - Sugar 1.mp3"

But be aware of a UNIX server that is Case sensitive and does not alow SPACES.

Good luck!
@WIN

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

in the DB you create a few fields:

ID| ARTIST | SONG TITLE | PLAYLINK

then you drag the Artist and Songtitle to your page.
Then you select both en you create a link to the dynamic Playlink.

Get a repeat regeon on it and you're done.

OK cool I beginning to understand now.

Is it also possible for admins to upload audio files from a webform, which also adds a link to the file into the database?

uploading has to be done by FTP,
but you can insert records in the DB with the option"Insert/Application Objects/records insertion form"

and you can create restricted pages with the server behaviour "User Authentication"


p.s. I hope youre using Dreamweaver MX!

YEah I am using DMX, but I'm still confused.

So I make the compressed audio file, then I upload that file to a folder on my server.

How does the record in the database know how to link to the audio files?, does this have to be done manually or can admins set up the link in an insert record form?, each record will also have 2-4 audio samples.

The website is here if you wanna take a look;
www.antibrandcorporation.com/vinylstore

Sorry to keep bothering you about this but I'm still pretty stuck.


Thanks for all the help so far.

&gt;<i>So I make the compressed audio file, then I upload that file to a folder on my server.</i>

Just upload a playable audio file (MP3, M3u....)

&gt;<i>How does the record in the database know how to link to the audio files?,</i>
Because you've created a extra field in the DB with the "<b>Playlink</b>"
like i did: <i>"file://2000server/mp3/Albums/Trance/Armin van Buuren/002 Basic Instinct/CD2/01 - Yahel - Sugar 1.mp3"</i>

&gt;<i>does this have to be done manually or can admins set up the link in an insert record form?</i>
you can do this in a insert record form with a <b>default value </b> of the playlink with <b>"file://www.antibrandcorporation.com/vinylstore/audiosamples/artist/</b> so you just have to type the filename

&gt;<i>each record will also have 2-4 audio samples.</i>
OK, than you put 2-4 buttons on the site for playing the audio...
maybe you better place dynamic buttons, so you dont see "button 4" when there are 3 audio tracks =&gt;create some extra fields in the DB <b> ID | Artist| Title| playlink1 |playlink2 |playlink3 |playlink4 |button1 |button2 |button3 |button4 |</b>


&gt;<i>Sorry to keep bothering you about this but I'm still pretty stuck.</i>
That's OK... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Good Luck

Your MusicBase Looks great @ !

Maybe we could meet and exchange

<img src="n:/Intranet2.gif" border=0>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Your MusicBase Looks great @ !

Maybe we could meet and exchange
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Yeah! We sure have to do that so our music collection can crow <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
Anyone else in here has got a lot of music ??