Blog - Tech / Database / Access

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. 

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.

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.