I am not a fan of watching movie clips, but these are really cool.

It is clear from the looks of this site that some major changes happened.

I combined the old reef site with my blog site to create a single personal portal. There is still some work to do (especially on the About and Photography sections), but at least the major work has been done. Moving from Movable Type to my new platform was not trivial, as no straight migration path exists. This means I have lost all my comments. I believe this will not be a train smash, so if you miss them - I invite you to register and post some new ones :)

I found this - and think it is awesome

Tonight I spent 3 hours trying to get a simple, basic SQL query to work in Microsoft Access 2003. The SQL query runs perfectly in Microsoft SQL Server 2005, however when run through the VB code in Access via the DAO layer it kept on failing with a syntax error. Obviously the error message did not point out the cause of the error. Since the SQL was perfectly valid and not complex, I was baffled.

Here is the basic query I had written:

select sum([table one].[field1]) from [table one] inner join [table two] on [table one].[field2] = [table two].[field2] inner join [table three] on [table three].[field3] = [table two].[field3] where [table one].[field4] > '2005-01-01'