Thread: Database.....
View Single Post
Old 23-07-03, 07:45 AM   #12
Jadesun
Queen of Sneak
 
Jadesun's Avatar
 
Join Date: May 2000
Location: Astle
Posts: 2,813
Default

I did find a nice program called Music Catalogue Master along with a serial....I've kept both the program and serial should anyone be interested....PM me...a la Waste she goes....

You put in your commercial cd's...voila all info is added thru the CDDB....you can enter records manually when it comes to those MP3 disks....but the track count only goes to 99..

I recall alot of other info loaded in as well..notes, artist info etc..

(For you savvy programmers, maybe you could boost the input count up to a high number such as 500) On the other hand, that may be able to be done thru Access...as I had noticed that this program made use of my Access, so I might be able to re-define the track count per CD....But for any of you interested in the program, I don't think you need Access on your system for the program to work..

Back to the limited track count per CD.....Say for ex. you have 120 songs on the MP3 CD, after 99 count it keeps adding as track 10...not overwriting, but you would end up with 99 tracks and 22 ( track 10's) make sense?

Then I thought I would ditch it for now...I will hang onto the proggie. All the while I was speaking of a small HD well after loading in like 25 commercial CDs and an MP3 disk, I realized the end resulting file size would be fairly massive, and in tracking my music in that way, it's not so much geared for others to view my listing.

For the time being, I will keep my database restricted to Excel...it's fairly simple and besides I can shove it into a text file quite easily for others to view my listing.

Thanks for all your help tho....

I was hoping to find a program, that wasn't overly flairy...so that I could load in all commercial CDs and MP3 disks, and run:

All by Artist which lists (ALL tracks) and (source CD for the track)
All by Genre
All by Format

I would be happy with just the above 3 reports. I don't need a report on year, price, where purchased...yadda yadda, yadda....

MS Access would be relatively easy..... for every Commercial CD there normally is 1 artist to many songs....BUT...by throwing in MP3 CD's...you have (Many to Many) which makes the database a bit more challenging to build...thinking somewhere I need a (junction table) (to combine One to Many & Many to Many) laymans terms: so that MP3's and Commercials can be merged/listed into one report per se

I think I'm thinking too hard and it's beginning to hurt

Anyway.....many thanks to all of you
__________________

(`'·.¸(`'·.¸¸.·'´)¸.·'´)
«¸¸©Jadesun¸¸»
(¸.·'´(¸.·'´`'·.¸)`'·.¸)

May each sun find you well

Last edited by Jadesun : 23-07-03 at 11:04 AM.
Jadesun is offline   Reply With Quote