Inventory of vinyl - what software do you use?


I am finally going to inventory my records this winter, or so I hope. I am wondering what software applications other Audiogoners use for this task. A specialized vinyl inventory program? MS Access or other database program? Also, what categories do you find most useful to keep a record of, besides Artist and Album name, condition of vinyl, record label, etc.?

I am not looking forward to this task but it is necessary, I think. I have been putting it on the back burner for way too long, out of pure laziness. I would like user-friendly software, with the ability to sort by field.

Please tell me what you use!

Holly
oakiris
I looked for something like this last year. I finally gave up and just set up a Excell spreadsheet. I pretty much logged the categories you've mentioned.

PLEASE, learn from my mistake. What ever you use, back it up!

A harddrive crash wiped out everything. I had also kept a category for what I spent on each lp and now that information is long gone. Not that it would have been that useful, but it was good to refer to from time to time.
I don't know your knowledge about software developing. But I made my record database with PHP and MySql. In this way I can access it from every OS with any browser. The following are the fields I am using :

id
Artist_Conductor
Composer
Album_Title
Record_Label
Product_No
Year_Recorded
Year_Produced
Genre
Format
Price
Recv_Grade
Grade
No_of_Discs
Bought
Web
Image
Tech_Rating
Music_Rating
Created
Modified
Comment

Rudy