We are trying to re-catalogue my father-in-law's inventory of over 400 guns into a more user friendly database. Many WWI, but mostly WW2 weapons (30+ M1 Carbines with different mfg or configs), etc.
Anyway, we have it all in an exhaustive spreadsheet, but I'd like to upload fields (or data entry) into a more robust database with a GUI of some sort that would allow him to search, sort, etc.
Anyone know of a program, or short of that, maybe even a programmer who could assist?
Risk the consequences of honesty...
I suck at it, but outside of using a table in MS Excel, MS Access might be worth looking at.
I enter data into a couple different Access databases at work periodically, and that’s what it does best.
“I won't be wronged. I won't be insulted. I won't be laid a-hand on. I don't do these things to other people, and I require the same from them.”
|quarter MOA visionary|
You would have to set it up with some work in the beginning but then you have a customized page that looks anyway you want.
|Fighting the good fight|
There used to be a well-known and highly regarded firearm database program, but the creator dropped off the face of the map a couple years ago and stop supporting/updating it, scamming folks out of their registration funds. Lots of pissed off folks out there as a result. (Looks like the website is still up, and may still even accept orders, but you won't get anything out of it.)
I use an Excel spreadsheet. You can both search and sort in Excel (and likely in the spreadsheet you're already using too). It's not as flashy as a custom database, but it does everything I need it to do.
^^^This. I personally love Access because it gives me the flexibility to store, search, and reflect data any way I choose. The newest version of Access is pretty user friendly (as DB's go), so you could likely get everything you want out of it with a little time commitment on your part.
Guns are awesome because they shoot solid lead freedom. Every man should have several guns. And several dogs, because a man with a cat is a woman. Kurt Schlichter
|On the DL|
An alternative to MS Access, is FileMaker.
Access is Windows only, FileMaker is Windows and / or Mac.
A mind is a terrible thing.
I’m sure that dedicated databases offer more options, but something that few people seem to realize is that Microsoft Word tables can be used for basic purposes. I have several data tables that contain about 350 to over 2000 entries. It’s possible to automatically sort the entries and search for specific terms with simple commands. I originally started using Access many years ago, but found that after converting the Access data to Word tables it was easier for me work with the latter.
“Most men … can seldom accept the simplest and most obvious truth if it … would oblige them to admit the falsity of conclusions … which they have woven, thread by thread, into the fabrics of their lives.”
— Leo Tolstoy
I use myArmscache. It's an App found in the App store and you can take pics and upload all kinds of gun data, accessories, etc.
'I am the danger'...Hiesenberg
NRA Life Member
|Little ray |
I'd just Excel, but if you aren't already a little educated, even an existing Excel spreadsheet would be a little intimidating.
The fish is mute, expressionless. The fish doesn't think because the fish knows everything.
Go with Excel/Access. You don’t even want to go toward a programmer and a custom built anything, unless you just don’t care about expense and want a customized turnkey operation. It’s just not cost effective. You can or you might find someone who could, whip together a VBA front end for either MS application. That might be reasonably priced, but honestly the best alternative is Excel.
Do not meddle in the affairs of wizards, for thou art crunchy and taste good with catsup.
I would use MS Excel and for searching and sorting, simply use the sort/filter and find/select features already built in
no programming required
Participating in a gun buy back program because you think criminals have too many guns is like having yourself castrated because you think your neighbor has too many kids
"I'm only myself when I have a guitar in my hands." - George Harrison
I went and made my own database using LAMP (linux, apache, mysql, php).
I built a little no frills web gui just to display stuff
This is where my signature goes.
i use an app called "my arms cache" its pretty good but managing 400 might not be what you need. The CMP also offers free software and worth looking at
That would be MygunDB? Guy is a total crook and he continues to take people's money.
|Fighting the good fight|
Looks like I got something right today.
|Delusions of Adequacy|
I've always had good luck using NM Collector.
The newer version is Java based, but the older Windows version is now available free. https://www.nmcollector.net/
I have my own style of humor. I call it Snarkasm.
|Drill Here, Drill Now|
I used to use a free program called GunSafe, but have since switched to Excel.
Thanks to this thread, it reminded me to update my list with recent acquisitions.
Ego is the anesthesia that deadens the pain of stupidity
DISCLAIMER: These are the author's own personal views and do not represent the views of the author's employer.
I spent weeks taking pics, logging serial numbers, accessories and inputting them into MygunDB. Then it crashed and shitstick is no where to be found.
|Muzzle flash |
In the distant past I used a product called GunTracker, but it went belly-up in 2016. It's a shame, because it was pretty easy to use and included the Blue Book data as part of it.
I did a search and found this free product: https://www.nmcollectorsoftware.org/. Installation was pretty simple (must follow instructions, though, because OS after Vista won't work if installed in the Programs folder). Product only for Windows and not specified for after W7 (it does run on my W7Pro machine). The product looks to be a good way to list data about firearms. I have not tried to use it yet, but it does have a sample entry that can be viewed.
Texan by choice, not accident of birth
When they ask me, "Paper or plastic?" I just say, "Doesn't matter to me. I am bi-sacksual."
|Powered by Social Strata||Page 1 2|