Page 1 of 1
Album Database

Posted:
Sat Jan 03, 2009 8:05 am
by jimmydanger
I'm creating an album database for my collection. I have 1000+ vinyl, 3000+ cds and 1000+ cassette tapes (from that brief period between records and cds). I'm using Visual Studio 2008, Access and Crystal Reports. Access is a dog, can anyone recommend a free database that's faster? This thing captures all the album vitals, as well as the musicians and tracks. I'll be doing data entry until 2012.

Posted:
Sat Jan 03, 2009 2:39 pm
by Shapeshifter
What? No 8-tracks?

Posted:
Sat Jan 03, 2009 5:07 pm
by jimmydanger
Ha, good one, I gave all my eight-tracks away when I didn't have a player anymore. I think the guy still has them.

Posted:
Sat Jan 03, 2009 7:22 pm
by gbheil
Sorry Jimmy cant help you out on the tech.
1000+ LP's ? Man thats a butt load of LP's.
I hear tell LP's are comming back. I have people in the shop once or twic a week looking for a turntable. I still have one but doubt if the stylus is any good after all these years in storage. Back in the 70's, the heads would hang the turntable on chains from the celing. You could dance your ass off in a peir and beam house and never skip a needle.
Those were the days man.


Posted:
Sat Jan 03, 2009 10:24 pm
by philbymon
Yeah, I've heard those rumors for about 20 years, now. "LP's are coming back." Sure they are. So are 16 1/2's & 78's. I just don't believe it. For one thing, they're just too damned big...of course you used to get some pretty cool posters with them. I got a rerelease of the Beatles White album on CD that had everything just exactly like the original LP, except of course the head shots & the poster were MUCH smaller. The entire album was exactly like the LP. 'Twas a cute idea, though. Wish they'd done that with "Dark Side of the Moon," if only because they changed so much on the CD. I won't play it cuz it pisses me off that they chopped it up like they did. Rat bastids!
Where was I going with this? Oh yeah - no, I DON'T think they're comin' back, folks. Wishful thinking aside, analog is not as expedient or efficient as digital. Before you know it, we'll all evolve into little blocky Lego ppl, all digitized for convenience & stacking purposes...heh heh heh

Posted:
Sun Jan 04, 2009 5:31 pm
by jimmydanger
Thanks Paradox. I downloaded the trial version and it's pretty cool. It uses an older version of Access for the database so I should be able to easily transfer the data to my db. I'll let you know how it goes.
Update: The trial version only lets you load 30 Cds. I ended up purchasing the program, they have it specially priced at $19.95 right now. The only thing lacking that I've noticed is no producer field, and no musician fields. But I can easily load that data once I have all the other data loaded. This is gonna save me hundreds of hours of data entry! Unfortunately I'll still have to enter the LP and Cassette data manually, but it's a labor of love.

Posted:
Mon Jan 05, 2009 12:34 am
by racefanrob
. . . I have over 800 vinyl recordings . . . 300 CDs and about 500 Cassettes . . . and a dozen 8-Tracks . . . I have an 8-Track tape player that works Y'all ! I have Hank Jr's first Lp that wasn't his Father's songs . . . "Country Shadows". He was seventeen when he recorded it and it is good. I have the Beatles old stuff . . . Swann . . . VEE JAY . . . and Capital. Someone lifted al lot of the good stuff though. All my Skynyrd . . . all my Zepplin . . . Pink Floyd (except "Dark Side of the Moon" and "Wish You Were Here") "Saucerful of Secrets", "Umaguma", "Atom Heart Mother", "Meddle", "Relics", "Oscured By Clouds" . . . all gone ! My Stones Lps are gone . . . MY CREEDeNCE LPs are GONE !
Y'all get the picture.

Posted:
Tue Jan 13, 2009 1:59 am
by jimmydanger
Well I got all of my rock and classical CD's loaded using the CDTrustee program after many pots of coffee and many late nights. Still a lot easier than typing it all in. The rock stuff was easy, but the classical stuff was more challenging; cddb (the database that the info is pulled from) gave conflicting or even wrong data for the classical stuff, so there was a lot of "load and scrub". But overall the program is awesome! If you have a lot of CD's you need this program. Next is the jazz stuff and then I get to manually enter the LP's and cassettes. I should be done by summer.

Posted:
Wed Jan 14, 2009 12:29 am
by Robin1
Hubby and I had a thing going about who did what song and I knew that I was right (Journey - When the Lights Go Down In the City) but to prove it the only thing we had the song on was a LP. So I got it out to play it and my then 6 yr old grandson said "I was wondering when you were going to play those giant CD's" OMG I had to laugh.

Posted:
Thu Jan 15, 2009 8:33 pm
by Andragon
haha big CDs. They dunno better.