Keeping track of your collection

[Josh Parr]

I'm curious to know how many people keep track of their collections and how they go about doing that.  I personally use a Microsoft Access database and create a new table per system.  Each systems tables are normally slightly different depending upon the medium that particular console uses.  Catridge based systems normally have Title, Box, Manual, Cartridge (only because I've listed games I don't have but want), Condition, Price Paid, Average Replacement Price.  Disc based games are normally Title, Case, Manual, # of Discs, Condition, Price Paid, Average Replacement Price.  I know that sounds really anal, but I like keeping perfect track.  Sometimes if I find another copy of a game in better condition than my current, if it's a good price I'll buy it and sell the other.  What are some other methods, because, even though I like my method and have gotten used to it, I'm wondering if there isn't something better out there.

[Brian Moy]

I'm thinking very few people likely do this, but I created my own online database w/ a CGI script.  If you're comfortable with CGI, hand coding and have your own web server to play on, you can get it for free (open source) from Extropia.  Inventory Manager lets you set it up basically however you like.  Although I didn't do this, you can create your own drop down fields for things like condition (new, mint, etc...) or check boxes if you want (for yes/no inputs).  The tough thing however is maintaining it as I tend to put it off.  Here's my loose parts list if you want to see.  The nice thing about it is that its sortable and searchable.  Might be just like your MS Access - I know nothing about that.

IGN also has a nice system I've noticed as a lot of people seem to use their account on that to keep track of their game titles.

[Josh Parr]

I tried the IGN system but it just didn't give me the freedom that I was looking for.  I'm not very good at hand coding, but what you are describing is very similar to what I'm doing with my Access database.  Freedom to add/remove fields, field type and stuff like that.

[Josh Parr]

I'm looking to working on a small little program to keep track of your game collections.  I've done some base work into it for personal use but depending upon how successful I am at coding it the way I want, might release it here on .  I'm not the best coder so it'll be a little finicky at the open, but with some work I'd really like to make a stable/useful piece of software.