Full Version: Music Dbase (access2000)
UtterAccess Discussion Forums > Microsoft® Access > Access Automation
SPJ29
Is it possible for me to add a mp3 file to each record of my existing CD dbase

I already have a dbase with all my cds could I link a track to it so as I could play it from the access 2000 dbase.
Philip461
Yes, it's easy, but i don't think you would want to. You can simply add a field to your SOng table of the datatype "Object". You can store the MP3 file in there. The problem is that your database will get HUGE! Also you will have to keep a copy of the file elsewhere so that you can play it with your MP3 player.

Ideally you want to store a pointer there (ie: a new field of data type 'Hyperlink'). WHen you click the link the song plays. This way you only need one copy of the file.
The problem with this is you need a good backup and restore utility, becuase if you have your entire music collection on a drive that fails, the only song you are going to hear is 'American Pie' (The day the music died).

I have been down this road before and have a semi-workable system that i have been working on for the past few years. THere is more to consider than you first might expect.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.