read mp3 tags into database fields

[zitvig]

Hello there!

As a hobby I was constructing a database of my CDs using MSAccess2002. Lately I decided to copy my CDs on an HD as mp3s.

Is there a way I can read mp3 tags into my fields so I don't spend hours copying and pasting song titles?

I would also like to launch songs from the database. I tried using hyperlinks and they work fine but I get a warning before launching each song (which then plays in WinAmp) that 'the file might contain viruses...' - how do I get rid of that message?

Thanks for sharing your knowledge and your time...

 

[Oppenhiemer]

Hi obsidian -

You will need to use a combination of system functions from within VBA in order to achieve what your after. It will mean doing some coding Im afraid :-(.

If this does not put you off, you will first of all need to list the contents of the disk using the "Dir" funciton. Then use the "WinExec" function with the appropriate arguments to launch the MP3 file.

I don think there is any way to avoid the warning using the Hyperlink method. This is because if you use a URL - its treated as any URL, and if it means recieving a program - it will warn you (as it does in a browser.)

Hope this helps..

Opp.

 

[Hitower]

Maybe this will help for reading the ID3 tag, i havent quite read it yet but its for getting ID3 tags from your songs

http://planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=5533&lngWId=1

regards Hitower

 

[Oppenhiemer]

Nice code example Hitower. Just also thought I would mention (not that you will need it if you use the code in question) that I mean that you could use the "Shell" function - not the "Winexec" function (getting languages mixed up ;-).)

Cheers..