Database Design & Discussion

I'm about to upgrade the PE format from Access 97 to Access 2003 (so that it can be opened with Access 2003-2016 instead of the current Access 97 - 2010). Does anyone have big complaints about this? For those hanging on to Office 97 and 2000 you should be able to install a newer MS Access runtime (*free).

DB Authors please read through: http://harpgamer.com/harpforum/index.php?/tracker/issue-134-problem-naming-individual-ships/?gopid=641&do=findComment&comment=641 It boils down to a suggestion that you add new ship and submarine names to the end of the list of names for the class so that scenarios built with an older version of your database will show the correct names when played with a newer version of the DB.

That's the new, the standard HCDB 1980-2015 platform database has been downloaded 10.000 times!!!

Please make all your Harpoon Commander's Edition (HCE) Americas Database (HCDA) requests for new platforms, changes to existing platforms, fixes and updates in this thread. It is much easier for me to track requests and changes if they are in one place. To recap HCDA design philosophy: The platforms (ships, submarines, aircraft, installations, and weapon systems) contained in the HCDA will cover (generally speaking) the 1980-2015 era, but this is not a hard and fast rule, and there are some exceptions. Like any database, the HCDA is always a "work in progress". There will be always be errors, typographical or otherwise, to some degree, so please be patient and…

File Name: HCStrikerFictDB File Submitter: TonyE File Submitted: 05 Mar 2007 File Category: Databases Database Description: This database is not intended to reflect reality, it is a collection of my own imaginary platforms and those of the people around me. There will be many versions of one of my favorite planes, the F-14, and my favorite ships, Iowa class Battleships. Please contact sysop@tgp.net with suggestions. *NOTE - The EC2003 & WestPac battleset scenarios will not work with this database, only scenarios written for this database will function. Click here to download this file

I'm having a problem with a new Mk41 VSL mount. I'll add the missiles I want add the mount to the ship the export the DB to the game but when I look at the ship it will say I have 17x 40mm Bofor cannon on that mount. I go back and check the DB and it is as I built it. I imported an older DB looked at my mounts and Is is it has changed to the 40mm Bofors load out. Someing happens when I export the DM. I've tried changing things around but always ended up with the same result. I don't think I broke any rule as I modeled my mount after other Mk41 VLSs I've seen in the DB. Anyone have a idea how to fix this?

As I tried to wrap my head around the idea of expanding the database limits, I keep coming back to the idea that we'll need a new database editor. MS Access is getting long in the tooth so a wholesale re-write might be nice. Well, the database storage mechanism will be a whole lot different so how do existing battlesets and scenarios get treated? Maybe their databases could be migrated to the new format. That train of thought led me to digging in old source code (from HC2002 actually) to see what Tools Bret had to dig information out of the legacy battlesets. It turns out he had a tool that exports any legacy battleset to the .csv files we are familiar with when usin…

WARNING !!! Aircraft entries 10469 Yak-38 and 11592 Yak-38M are rated as with "Propulsion: Jet, CVL cpbl", if that is not changed to "Propulsion: VTOL & Helicopter", they can't be loaded building a scenario on the Kiev-class and derivatives CVH (ship entries 2147, 3325, 2148, 2263), rated correctly as with only a VTOL runway. And if I changed it on my DB and make a scenario, the scenario very probably will crash when playing in a not-modified on that sense DB.

This discussion branched off from the EW hands on Red flag topic into a full blown DB discussion, so let me copy it over here, the proper place. The bonus is that Enrique's post from 2012 is just few topics away from here, that one is probably the Philosopher's Stone of RCS so far!! (If forum admin could replace this post with posts #17-#31 from the "EW hands on: Red Flag - Russians invited" topic in General that would be even better.) (( Damn, forum doesn't allow me to just quote the other posts, too many quotes ..., attempt to copy them unquoted.)) Here it is: Grumble, on 31 May 2014 - 02:13 AM, said: I just played my first scenarios with the Westpac battle…

In my main computer something has happened with the DB editor, and is destroying the DBs in modification. Each time I try to import a common.res file, the DB is in blank,even importing correct DB files from the other computer, or downloades from the Harpgamer site. It says the error is here in "Modules" and in the section "cFileIO" , but I don't know as to repair it: With rsArray .AddNew ![Annex] = LastAnnex ![iD] = LastID ![subAnnex] = SubAnnex ![Array] = Format$(ArraySize, "0") & ArrayVal .Update End With LastID = -1 Were I should to look to find the LastID = -1 and change it?

Ok. If I understand this correctly - essentially the commondb.res is the database for weapons/sensors/platforms (ships/subs/airplanes) and bases. AS I recall somewhere there is an application that will convert the file (commondb.res) into either Microsoft Excel or Access Database format - a little easier for viewing and analysis. What is the application that I am thinking about? Should it already be on my computer with Install of harpoon - or where is it located within the HARPGAMER site. thanks in advance

The Kfir C.7 is perhaps the most powerful IAF a/c asset of the HDS3 and later MEDC scenarios. In HCE the Kfir is rated at 1516 kts top speed which enables it to choose the fights it wants to fight disengage from the rest and reach any critical spot around Israel quickly. It also easily outruns the Damascus Gammon SAMs (1434kts), which would otherwise be a major headache for blue for the MEDC scenarios. Is this top speed for real or is this a typo? The Wikipedia article actually lists the Kfir C.7 with Maximum speed: 2,440 km/h (2 Mach, 1,317 knots, 1,516 mph) above 11,000 m (36,000 ft) In the original MEDC the Kfir had 1317 kts top speed from HDS3 on it has 1516kts. …

As consequence of some post interchanged with Brad the other day, I've make a chart about the plane carrying capacity of a great number of Aircraft Carriers and other plane-capable ships. First, some comments about it and the numerical values in the attached file. Basically, as commented a few days ago, I've detected some incongruence in HCE/HUCE Databases, I think now the problem comes from the paper rules and from his application to Computer Harpoon and his DBs. In the paper rules it's not the numerical limitation of the Computer Harpoon database, and a player can research in naval books and do changes in plane capacity as result, it's only a pencil and pap…

Greetings, I have been working on a few scenarios in the Caribbean and Sub-Saharan Africa region and have seen there is a lack of any airfields in the HUCE DB for these areas. While I was driving into work this morning and idea hit me - INTL Arfld Lg and INTL - Arfld Sm. Like any other unit in the new group, they can be placed anywhere. Basic numbers could be assigned for their air defense and any additional SAMs can be separately placed around the units. Large airfields could handle all large fixed wind aircraft, while the small version would only be capable of suppporting VSTOL and helicopters. I believe this would be a very beneficial addition in the next H…

Some considerations about the MiG-31 Foxhound and his variants, after the latest news of the March 2012 issue of Air International, and the book MiG-31 - Famous Russian Aircraft, by Yefim Gordon, Ian Allan – Midland 2005: The MiG-31M Foxhound-B development ceased near 1997 (for the english version of the Wikipedia and other books or sites the MiG-31M is confused with other variant or variants of MiG-31, and erroneouly stated as “in service”, and equipped with in service K-37 missiles). The MiG-31M Foxhound is a new airframe with six supports for big AAM in the underbelly, the other variants have only four supports. The K-37/AA-X-13 Arrow development ceased als…

Hi, I am trying to track down which Gearings and Sumners were updated while on Turikish service with Harpoon and 35mm dual guns - the DB shows only 2 of them, but I have found photographic evidence 3 were so updated, so I am trying to find out how they looked in the 90s, and it seems all photos on the web were taken from the bow! Any help, please?

For database purposes, is there any differences in using a Block10/20 Global Hawk versus a separate BAMS entry? From what I can tell, it's a navalized G-Hawk, but no distinct differences jump out at me. I have an HoA scenario almost 90% done, but just wanted to eke out as much authenticity as possible. Thanks

A very interesting document, with APS-127, APS-134(V), APN-133(V), APN-215(V) tested by the USCG: http://www.dtic.mil/cgi-bin/GetTRDoc?AD=AD...oc=GetTRDoc.pdf

Greetings, Is the SKRUNDA (AR SWATH) PB for Latvia, part of the HUCE DB? Two of four units have been delivered as of 2012 and I was wanting to utilize it, in a planned scenario in my BRICS campaign. If you need details on the class, let me know and I can provide them.

Japanese site (in simulated/automatic translator English!) with details of the Kawasaki P-1 (radar, sonobuoy processor, illustrated with 8xASM-1E, etc ... Is the only site where I've finded the approximative wing area), and some notes of humour with the P-1 speculative variants painted in RAF or Japanese 1942 styles: http://www.heinkel.jp/yspack/ysf_p1_eng.html The text says the HPS-106 is very similar to the modelled APY-10. Other Japanese projects: http://www.heinkel.jp/yspack/yspack_eng.html Including details about rare Japanese weapons, as modern deep charges: http://www.heinkel.jp/yspack/ysf_weapons_eng.html