|
Peer to Peer The 3rd millenium technology! |
|
Thread Tools | Search this Thread | Display Modes |
21-07-03, 12:46 PM | #1 |
Queen of Sneak
Join Date: May 2000
Location: Astle
Posts: 2,813
|
Database.....
Does anyone use Access for their music database...(I've just about had it up to here with Access)...altho it's ideal to use.
or is their a good program that will..... I'm looking to enter my cd's in by title, artist category, format and track listing...and that being said when all is said and done...generate reports... list all CD's, DVD's, MP3's for a particular artist list all TRACKS for a particular artist (all formats & categories) list all according to FORMAT, cd, mp3, dvd etc.. list all for CATEGORY, rock, pop alternative....etc... I tried the database that Microsoft provides for Access, and it's not quite the reports I'm looking for.....it's pretty cheezy really for Access.....Excel is doing that for me now. Thanks
__________________
(`'·.¸(`'·.¸¸.·'´)¸.·'´) «¸¸©Jadesun¸¸» (¸.·'´(¸.·'´`'·.¸)`'·.¸) |
21-07-03, 12:51 PM | #2 |
yea, it's me.
Join Date: Jan 2002
Location: usa
Posts: 2,093
|
I love you Jadesun..........but that doesn't stop me from hating you for being so.......so......organized
|
21-07-03, 02:12 PM | #3 | |
Queen of Sneak
Join Date: May 2000
Location: Astle
Posts: 2,813
|
Quote:
I gotta, it's a royal pain in the arse when going to make a cd for myself or friends and they pick out the 15/20 songs they want...instead of having to... trial and error find, I like to hit the find the first time. I just think all things have their place...and it's easier if these things are in the 'right' place.... Organized I have all my commercial cd's in alphabetical order, in the cd tower/shelf unit.....the ferrets, Nikki and Ambi like to push em off shelf by shelf and bulldoze thru em...and there I am again, puttin' them all back in order...will I ever learn
__________________
(`'·.¸(`'·.¸¸.·'´)¸.·'´) «¸¸©Jadesun¸¸» (¸.·'´(¸.·'´`'·.¸)`'·.¸) |
|
21-07-03, 02:57 PM | #4 |
Dawn's private genie
Join Date: May 2001
Location: the Canadian wasteland
Posts: 4,461
|
I don't have a clue if this is what you want because I'm a digital slob but I just saw this a few seconds ago.
http://www.songs-db.com/features.php |
21-07-03, 03:15 PM | #5 | |
Queen of Sneak
Join Date: May 2000
Location: Astle
Posts: 2,813
|
Quote:
I really think Access is probably my best bet....but I loathe the thought. PS: If I come up with this ideal setup in Access, you will all be welcome to it
__________________
(`'·.¸(`'·.¸¸.·'´)¸.·'´) «¸¸©Jadesun¸¸» (¸.·'´(¸.·'´`'·.¸)`'·.¸) Last edited by Jadesun : 21-07-03 at 05:53 PM. |
|
21-07-03, 06:03 PM | #6 |
How may I help you?
Join Date: Jun 2002
Location: Los Angeles, CA, USA
Posts: 210
|
Maybe some cataloging software helps. This is the best by far -> WhereIsIt. It has plugins for various media files, extensive search capabilities and a report generator as well. I'd be completely lost without it.
|
21-07-03, 10:55 PM | #7 |
Registered User
Join Date: Jun 2003
Posts: 4
|
|
22-07-03, 04:56 AM | #8 | |
gone for good
Join Date: Jul 2000
Posts: 2,271
|
Quote:
|
|
22-07-03, 08:12 AM | #9 |
WAH!
Join Date: Apr 2001
Posts: 725
|
I use fillemaker pro to catalog my cdrs.
i think you'll like it better then access. i did.
__________________
I hate hate haters |
22-07-03, 12:28 PM | #10 |
Registered User
Join Date: Jun 2003
Posts: 4
|
Ooops! I am an idiot.
|
22-07-03, 04:15 PM | #11 |
Alien In a Penguin Suit
Join Date: May 2003
Location: Earth
Posts: 265
|
Something like this?
http://www.base40.com/ I have a good one at home I will get info and post later also.
__________________
TheOnlyBob |
23-07-03, 07:45 AM | #12 |
Queen of Sneak
Join Date: May 2000
Location: Astle
Posts: 2,813
|
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¸¸» (¸.·'´(¸.·'´`'·.¸)`'·.¸) Last edited by Jadesun : 23-07-03 at 11:04 AM. |
23-07-03, 08:53 AM | #13 |
Join Date: May 2001
Location: New England
Posts: 10,024
|
wow jadesun, when you're done with yours could you please come over to my place and do mine?
- js. |
23-07-03, 10:31 AM | #14 | |
Queen of Sneak
Join Date: May 2000
Location: Astle
Posts: 2,813
|
Quote:
__________________
(`'·.¸(`'·.¸¸.·'´)¸.·'´) «¸¸©Jadesun¸¸» (¸.·'´(¸.·'´`'·.¸)`'·.¸) |
|
Thread Tools | Search this Thread |
Display Modes | |
|
|