Blog

Create an MsAccess Oracle like DUAL table

Sep 18 at 10:59am | 0 comments

Had a need to replicate some logic used in Oracle into an Access db.  The oracle DUAL table is very handy.  I found this article on creating a hidden dual table.  It looked interesting but I didn't fully vet it.

Formatting Date and Time in Ms Access

Sep 15 at 5:10pm | 0 comments

I just have the hardest time trying to find 'time format' for MsAccess.  So I'm capturing the link and info here.

Speed Test For Cold Fusion

Sep 10 at 11:17am | 0 comments

I had a web hosting service for ColdFusion that was seemingly running slower and slower and slower.  I needed a way to validate what I was seeing.
After running SpeedTest on my current hosting, it took 40-50 seconds to return.  I later determined that this was on a shared hosting service using CF8 and W2003 ( http://www.crystaltech.com )
I've since moved off that service and I'm on CF9 and w2008  (http://www.hostek.com ) and that same SpeedTest returned in under a second.

Stored Procedures in Access via Cold Fusion

Sep 10 at 11:08am | 0 comments

Found a way to call Ms Access queries from Cold Fusion.  Sometimes I don't have an option and have a MsAccess db backend.  One benefit to calling a query via a stored procedure is that my code is more modular and reuse. 

IIS Manager for Remote Administration

Sep 10 at 11:01am | 0 comments

Found this article on what you need to install for some shared windows hosted sites that give you the ability to access IIS manager remotely