What database do you use? (DB for download)

ketko · Post by **ketko** » 19 Sep 2008, 16:50

Hi all,

I was wondering, what software do you use to keep your logs.

Do you use some commercial product or do you build your own database using Access,...?

If so, I would be glad if you could post some screenshots here.

Best regards, Keishi

Moderators: Sorry, I didnt know where to post it. If its in wrong section, could you please move it? Thank you very much.

Post by **Key** » 19 Sep 2008, 23:50

Moved indeed, Keishi, thx for understanding.
We had a similar topic a while ago, a search should bring it up.

Erik

sfeyenoord1 · Post by **sfeyenoord1** » 25 Sep 2008, 20:51

Noticed this tool on Aviationphotos.org:
http://www.aviationphotos.org/software/

Might be handy for whoever is looking for a database

jaah · Post by **jaah** » 30 Sep 2008, 18:17

sfeyenoord1 wrote:Noticed this tool on Aviationphotos.org:
http://www.aviationphotos.org/software/

Might be handy for whoever is looking for a database

Does anyone know of a database for military spotters?

SquAdmin · Post by **SquAdmin** » 30 Sep 2008, 18:36

sfeyenoord1 wrote:Does anyone know of a database for military spotters?

http://www.scramble.nl/milbase.htm" onclick="window.open(this.href);return false;

Redskin301 · Post by **Redskin301** » 30 Sep 2008, 21:02

Ik gebruik MASR het liefst als ik ff wat moet opzoeken

jaah · Post by **jaah** » 01 Oct 2008, 16:39

SquAdmin wrote:
sfeyenoord1 wrote:Does anyone know of a database for military spotters?
http://www.scramble.nl/milbase.htm" onclick="window.open(this.href);return false;

Yeah, I know. I meant for my own logs

.

Fly Fort · Post by **Fly Fort** » 04 Oct 2008, 16:32

Take a look at my picbase at http://www.milair.info/Picbase" onclick="window.open(this.href);return false;.

Maybe something like this???

Piet Luijken · Post by **Piet Luijken** » 05 Oct 2008, 10:54

Excel.

Columns for general aircraft type (F-4), actual aircraft type (RF-4E), squadron, wing, defence force (AF, NY, AR, GVMT, civil) and country.

One is sorted by date and one is sorted by country.

pascal · Post by **pascal** » 07 Oct 2008, 19:33

'Hi,

I'm just working on a Microsoft Access format for my logs and serials.

Any other Access users for the logs and serials?

Gr Pascal

ketko · Post by **ketko** » 08 Oct 2008, 09:10

Hi,

I use Access too. I have created a set of tables, one for airframes which includes ID, which is the CN with a prefix, so I can set it as a unique value (for eg. A32S.2143), then it has the CN itself, LN, Manufacturer, Type and Subtype. It also includes frame type (jet, prop,...) and the registration it was wearing when last seen.

The second table is called Sightings and it includes data about each sightings of a particular airframe - ID to relate it to the previous table, Registration, Operator, Location, Date, Remark and a * if it is first time seen.

Last main table is table Photos, which is unrelated to the other two, however I have an auto-fill on my form, so it automatically fills remaining data after entering registration of the plane on the photos. It also contains location of the photo on the disc, so it can display it.

Beside that, I have a couple of forms and reports, which help me organizing/browsing the data.

Firstly there is the main form, which just has buttons to go to the others.

Then there is the 'logging tool', which I use to input data about the sightings. The upper part contains detail about the frame selected in the bottom part. The default data for the new sightings can be set on the main page for the ease of inputting frames from one trip.

Finally, there are two forms for managing/browsing the photos table.
First is a form for adding them. And the second is for browsing. The browsing form isnt great, but Im working on making it better.

I also have created some report, for the ease of browsing.

That's it. Firstly I wanted to buy ADU or some other commercial product, but then, I found iout, that I dont need tens of thousands of airframes already in, so I decided to craete my own one and Im happy with that decision to say.

Now I only have to input three years worth of frames/sightings/photos.

Best regards, Keishi

MainPower · Post by **MainPower** » 08 Oct 2008, 09:41

Nice explanation Keishi. It's good to 'see' how other people do this.

Cheers,
Matthijs

Post by **Key** » 08 Oct 2008, 11:44

Well done, Keishi. Clear explanation of a great tool.

Erik

ketko · Post by **ketko** » 19 Nov 2008, 22:11

Hi all, recently, I got a couple of requests to send my database and so I decided to upload it. You can download here, if you're interested in it too.

http://rapidshare.com/files/165446262/K ... accdb.html" onclick="window.open(this.href);return false;

Regards, Keishi

jaah · Post by **jaah** » 20 Nov 2008, 17:03

ketko wrote:Hi all, recently, I got a couple of requests to send my database and so I decided to upload it. You can download here, if you're interested in it too.

http://rapidshare.com/files/165446262/K ... accdb.html" onclick="window.open(this.href);return false;

Regards, Keishi

It says the download limit has been reached. Can you upload it again please?