Posted: 1/24/2012 6:57:54 AM EDT
|
I have been developing different Microsoft Access database for the last year. The more and more I build them the more I find neat things you can do with them. Now I am building these in Microsoft Access but I transfer them over to Libre Base to use at home with my Linux box. So after building all of these for work type stuff it clicked, I could make one for logging QSO's That way I can get all the data I want, nothing more nothing less. Im about 3-4 hours into it and its pretty cool. So far I have the
main database QSO input form QSL manager Graphs by band and mode QSL report maker to print mailing labels for my QSL cards Attachment tool. This way on the input form I can attach files to the QSO. Such as a recording, txt file, SSTV image, E-QSL, ect ect I know there is logging software out there but this is mine, plus I can change anything I want whenever. So does anyone else play with Access? If you have no idea what Access is just think of Excel on crack. |
|
I have in the past, quite a bit. It is nice for quick little things, but I can't even count how many larger business applications I have been hired to re-write that were just too big for access. It always amazes me... some of these companies spend 250k on an access application over the course of several years, then have to throw the thing out to be written as an application with a true SQL backend, be it MySQL, MSSQL, PostgreSQL or whatever.
I do like it for small projects, as it is quick and fairly powerful. But for anything that needs any serious horsepower I find myself using a true SQL server and writing the application in .NET, PHP, Ruby or something similar. |
|
Im still learning about SQL and what not. I like access because of how simple it is. If I want to create a graph of contacts made by band it takes about 5 mins. I have seen where larger ones tend to get slow but I dont think this one will get that big, and hopefully by the time it does I will have learned a little more programing.
Since Access can read from SQL servers could you not just use it as a front end and keep the data in the SQL? The ability to make graphs and reports so quickly and easily is a huge plus. Oh and BTW I bet you can only guess how many times I have typo'd QSL as SQL in this project. |
|
QRZ.com changed their URL structure to disallow lookups like what you're doing. I think they only allow direct query by XML now. You can find info on queries here: http://www.qrz.com/i/xml_data.html and http://www.qrz.com/i/current_spec.html |
|
Quoted:
QRZ.com changed their URL structure to disallow lookups like what you're doing. I think they only allow direct query by XML now. You can find info on queries here: http://www.qrz.com/i/xml_data.html and http://www.qrz.com/i/current_spec.html It would be awesome if I could get Access to populate the fields with that info, but its a little outside my skill set. the DB way still works http://www.qrz.com/db/w1aw I heard about them changing it too but it doesn't seem to affect me |
|
Quoted: Im using '07 the .gov isn't high speed enough for 10. Tonight Im going to see what happens when I try importing my nearly finished (Im kiding myself) database into Libre Base. I like '10 much better.....you can copy and paste and fill down. I had a hard time doing what I do using '07. |
Fortunately I was able to quit using Access before it drove me to kill myself. 
I think the last time I actually launched it was in the VB5 days when building pre-SQL Server proofs of concept. I guess that was around the mid-90s. I don't think I've physically touched Access in at least 10 years. |