Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Durkin Tactical Franklin Armory
User Panel

Site Notices
11/2/2022 4:30:06 PM
Page / 2
Next Page Arrow Left
Link Posted: 11/6/2011 3:50:32 AM EST
If you are having trouble inputting data and getting read only errors, make sure you actually extract the DB from the zip file.  If you open it inside the zip file you won't be able to use it properly.

ETA:  Thanks TC2 - the DB looks great.  I am going to use it later today and see what I come up with.


Any suggestions are very welcome. If Open Office ever gets upgraded to include HSQL 2, I'll be able to add auditing to satisfy ATF requirements.
Link Posted: 11/6/2011 3:56:38 AM EST
This thread is very relevant  to my interdasting. .  

I was half-assedly working on a Bento-based  template for my armory  collection, but i got  distracted.  Bento is a Mac platform Filemaker based db program designed for morans such as myself.


I tried doing that with a trial of bento and had no luck at all....
Link Posted: 11/8/2011 8:14:55 AM EST

Link Posted: 11/8/2011 12:23:06 PM EST

Yep, working on it.

Actually, it's only #1 that's proving to be less than straightforward:

1. All data entered into the computer system must be recorded into the database and
 cannot be capable of being edited or modified at a later date without generating an
audit trail. The software system must retain any correction of errors as an entirely
new entry, without deleting or modifying the original entry. The system may allow
for entries in a notes column to explain any correction.

To implement this in a practical manner in OpenOffice requires an update of the database engine, which, although pretty easy to do, is going to be a nuisance for users. So, I'm not sure whether to wait until OOo is finally distributed with the updated engine, or to start giving updates assuming users will update the engine on their own.

2. The system must have a reliable daily memory backup capability to protect the data
 from accidental deletion or other system failure.

#2 is built into Open Office: go to Tools > Options > Load/Save > Always create backup copy. The path to the backup copy can be modified: Tools > Options > Paths > Backups.

3. The system must meet the regulatory requirements for recording pertinent

I think I have #3 covered.

4. The system must allow queries by serial number, acquisition date, and name of the
 manufacturer or importer. Commonly recognized trade names may be used when
recording the manufacturer/importer in the firearm description.

Covered. I plan on putting ready-made queries into the database, but this one's easy.

#5 and following have to do with printouts, and should be fairly easy to implement. Saving the data as ASCII might be an issue; I haven't looked into it yet.
Link Posted: 11/8/2011 2:10:06 PM EST
Update: firearms-0.1.9.zip (Uses Open Office (free for Windows, Mac, and Linux))

This is the last update before being "released" as v0.2.0. Please poke around through this version and let me know if there's anything that's broken! The screenshot probably looks exactly the same, but there might be some "bugs" that are only apparent with a little use.

After "releasing" v0.2.0, further updates will probably be 1) weeks to months away, 2) designed more with use by an FFL in mind, and 3) still totally free. v0.2.0 should be perfectly suitable for maintaining a simple database of personal collections.

Link Posted: 11/8/2011 2:25:06 PM EST
Corrected the title.
Link Posted: 11/9/2011 12:59:05 PM EST
SURELY someone has comments on this, if not suggestions?
Link Posted: 11/9/2011 1:09:45 PM EST
I downloaded your file and started using it.  First thing I found was that there is no place to enter accessories.  Most of my rifles have scopes that are worth as much as the rifle in addition to special triggers and other items.

There is plenty of room for editing so I'll let you know what I come up with.

I'm thinking about this one, but as it actually requires legitimate database design, it might take me a while.

I'm an admitted database amateur.
Link Posted: 11/13/2011 12:06:56 AM EST
Update: firearms-0.2.0.zip (Uses Open Office (free for Windows, Mac, and Linux))

Here you go. Suitable for personal collections.

I'm working on a version (to be released as "version 1.0") that can be used as an electronic "bound book." The way it's shaping up, you'll be able to add (practically) unlimited entries, and about as many pictures to each entry. I'm only planning to implement the audit trail for ATF-required data. I'll have more details as I make them up.
Link Posted: 11/13/2011 12:13:04 AM EST

Link Posted: 11/13/2011 4:47:52 AM EST
Bump for the day crew.
Link Posted: 11/13/2011 5:31:23 PM EST
Major update:

The ATF-compliant version, a work in progress, but functional: http://www.ar15.com/forums/topic.html?b=1&f=5&t=1252871

Link Posted: 11/19/2011 11:30:13 AM EST

I am finally getting around to finishing up recording my collection.  How do I get pictures into the document?
Link Posted: 11/19/2011 12:58:46 PM EST

I am finally getting around to finishing up recording my collection.  How do I get pictures into the document?

It's probably best if you put the image files in the same directory as the firearms.odb file (or in a folder called "img" in the same directory as firearms.odb).

Then, double-click on one of the blank spaces. This should open up a file-selection dialog box to select the image you want.
Link Posted: 11/19/2011 1:23:49 PM EST

I am finally getting around to finishing up recording my collection.  How do I get pictures into the document?

IM sent, in case you try out the newer, ATF-compliant version.

Basically, use these instructions to export your data from firearms.odb before setting up the HSQLDB 2.2.5 engine.

Instead of the GUN table, though, open the Table1 table.
Link Posted: 11/24/2011 5:35:14 PM EST
This thread is now deprecated.

Please see the new thread.
Page / 2
Next Page Arrow Left
Close Join Our Mail List to Stay Up To Date! Win a FREE Membership!

Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!

You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.

By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.
Top Top