Frequency database management...what are you using?

[MacombMonitor]

What is everyone using for a database to manage their frequency information?

Years ago, I used to use dBase. I don't like Microsoft's Access. I've tried File Maker Pro, not too bad. I have and older Spectrum CD, that uses FoxPro, which is nice, and very similar to dBase. A lot of people use Microsoft's Excel, but that's not a database, it's a spreadsheet, and lacks a lot of "database" options.

Thanks!

 

[Audiodave1]

Hello,
I use Access and Excel.

Why? They are familiar. Excel to format data, Access to store it.

Dave

 

[Al42]

I use Win95 - I don't need anything more than that. If I did I'd use an Access mdb (easier and a lot smaller than a SQL database) with a GUI front end.

If there was a consensus about what's needed I'd write something, but everyone wants something a little different.

 

[Voyager]

Hello,
I use Access and Excel.

Same here. I use Excel more since it's easier to insert records in the middle of the data. My datafile is getting large enough that the 65,535 record limit Excel has is starting to show it's going to be an obstacle down the road.

Joe M.

 

[AC0RV]

I use Microsoft's Works Database.

 

[Dubbin]

I just use whatever software I have for the radio.

 

[SAR923]

I just use Win96 to store frequency data. It's easy to use, reliable, and I can always export to Excel if need be. I've probably got 20 Win96 files that have all the frequencies I'll ever need while travelling and Win 96 makes it easy to download them to V-Folders when I need them.

If I didn't have Win96, I'd probably be using Excel. It's just a flat file database but you can do some pretty cool things with it using pivot tables.

 

[Jay911]

I use OpenOffice's spreadsheet element. Essentially, a free and better version of Excel.

I have all my frequencies and talkgroups and such in one "workbook", and have a number of pages which will percolate the data out into any text-readable format I want - including one that needs minor editing in a text editor before being able to be "uploaded" as a text file via Hyperterminal into the scanner.

 

[kf4lhp]

I'm using a homegrown Access database - built the table with fields for licensee, callsign, use, location, base/simplex frequency, repeater in frequency (just left blank if simplex) and squelch code. Has worked great for me since Access 2.0 came out on a few dozen floppy disks many years ago. Running it on Access 2000 now.

Nice thing with Access is you can build queries, I have query by callsign, frequency, licensee, and a few category queries set up.

--mws
http://www.scanchattanooga.com/

 

[Admin0140434]

Same here. I use Excel more since it's easier to insert records in the middle of the data. My datafile is getting large enough that the 65,535 record limit Excel has is starting to show it's going to be an obstacle down the road.

are you utilizing the sheet tabs? for example... one sheet for statewide frequencies, one for your county/city, etc., etc.

i JUST starated using access for my database (seriously... like 30 min ago)

 

[Voyager]

Same here. I use Excel more since it's easier to insert records in the middle of the data. My datafile is getting large enough that the 65,535 record limit Excel has is starting to show it's going to be an obstacle down the road.

are you utilizing the sheet tabs? for example... one sheet for statewide frequencies, one for your county/city, etc., etc.

i JUST starated using access for my database (seriously... like 30 min ago)

Nope - one sheet for everything. That's the only way I can sort on everything.

Joe M.

 

[FPO703]

I use the Radio Reference Database. :lol: