Insert link to music in database Access 2010

[poorrich]

I am making a database of MP3 songs. I want to include a link to each song and be able to play the song from the database by clicking on the link.

[June7]

Bing: Access database play sound file

http://www.techonthenet.com/access/q.../play_wav2.php

Do you want to embed the files in attachment type field?

http://www.vbforums.com/showthread.p...ccess-database

Or do you want to save path in text field and hyperlink to external file?

http://allenbrowne.com/func-GoHyperlink.html

[ranman256]

I would have a field in the table called [PATH], with the full path to the file.

Show your list of songs in a form, put a button in the header that says PLAY
on the button CLICK event put:

call Shell("c:\windows\Mplayer.exe " & me.Path, vbMaximizedFocus)

(but this already exists in all music players)