Monday, 28 February 2011

I Forgot What Access Was Like...

I haven't used MS Access for a fair while now. There was a time when I used to have use it loads. Thankfully not so much now. The more the years have gone on the more the glorified filing system has got annoying. I remember the good old days of 97 when it did what it said on the tin and didn't try to be too clever for it's own good.

I have had the unfortunate opportunity of using it again today in anger. What a ball-ache! That much of a ball-ache that I decided to blog while I, once again, wait for this update query to run (which would take a matter of seconds in SQL Server). 20 minutes in and I'm slightly bored!

That coupled with my previously stated hatred of IIf, that got right on my tits! So another annoyance to add to that is that you can only have up to 6 nested IIf statements - great! I needed 36. Switch was no good either - that only goes up to 15 (at least in the query editor anyway).

So regular crashes and constant "not an updateable query" messages later - I'm still waiting... Roll on tomorrow so I can get back to a real database and a proper programming language!

Friday, 4 February 2011

Blogger App on Android

Finally here! An android app for Blogger >>

So in honour of it here is a post using it.

Biggest issue far is that there is no formatting - not even basic stuff. But I'm sure that will come...and existing posts aren't available to view.

Thursday, 3 February 2011

If You Can Think Of It, It Will Happen!

Just had a really good one :)

If there's a faint possibility that a parameter for a routine might change, I whack it in the config. Now doing what I do means I work with a lot of different types of coders some good (not many) and some bad (surprising how many!). Anyway, one particular guy is one of those why would they ever want to do that or what's the point, that'll never happen types of guys. Fine - if he wants to do as little possible then that's fine. But. And it's a big but.

Today, the remote mail server they use for emailing from within their web applications has been changed and no longer allows remote mails to sent. Oops!
So all smug I say "just swap the mail server address that you'll have used in your config to use localhost - everybody's happy"
Him - guess what it was...drum roll..."like that's gonna happen, they're all hard coded, gonna take ages to swap all them!"
Me (raising my eyebrows with a small lips twist): "oh well..."

So I feel really good about that :) A classic example of if you can think of it, it will happen syndrome.


.net (7) ajax (1) android (7) apache (1) (3) asus (2) blogger (2) blogspot (3) c# (16) compact framework (2) cron (1) css (1) data (1) data recovery (2) dns (1) eclipse (1) encryption (1) excel (1) font (1) ftp (1) gmail (5) google (4) gopro (1) html (1) iis (3) internet explorer IE (1) iphone (1) javascript (3) kinect (1) linux (1) macro (1) mail (9) mercurial (1) microsoft (3) microsoft office (3) monitoring (1) mootools (1) ms access (1) mssql (13) mysql (2) open source (1) openvpn (1) pear (2) permissions (1) php (12) plesk (4) proxy (1) qr codes (1) rant (4) reflection (3) regex (1) replication (1) reporting services (5) security (2) signalr (1) sql (11) sqlce (1) sqlexpress (1) ssis (1) ssl (1) stuff (1) svn (2) syntax (1) tablet (2) telnet (3) tools (1) twitter (1) unix (3) vb script (3) (9) vba (1) visual studio (2) vpc (2) vpn (1) windows (4) woff (1) xbox 360 (1)