Home    Blog

Blog - Tech / Database / Access

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.

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.

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.