MS Access 2000 database for querying GrantLog files from Pro96com
I attached a simple Access database I threw together to query the GrantLog’s that Pro96com produces. I made queries to search by talkgroup, search by radio id, show unique unencrypted talkgroups, and show unique encrypted talkgroups (which shows a count of how many times the talkgroups were recorded in the GrantLog).
I made this database in Access 2007 but then saved it out as Access 2000 so people could use it in earlier versions of the software too. There’s no data in the attached file--just the database structure.
I’ve been appending my most recent grant log to the GrantLogTable and then changing the name of the GrantLog csv file on my computer so the next time I open Pro96com, a new GrantLog csv file will be creating and I’ll append that one into Access next time to avoid getting duplicates and repeat the process.
Obviously you can use this to analyze any system’s GrantLog files: MDICE, Starcom21, etc. With MDICE being new and the amount of encryption being used, it’s nice to be able to see what units have been on what encrypted/unencrypted talkgroups as well as have an up-to-date list of all the unencrypted and encrypted talkgroups logged.