UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Music Dbase (access2000)    
 
   
SPJ29
post Aug 6 2004, 05:40 AM
Post #1

UtterAccess Enthusiast
Posts: 53



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.
Go to the top of the page
 
+
Philip461
post Aug 6 2004, 08:11 AM
Post #2

New Member
Posts: 10



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.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 08:39 PM