Skip to main content

UPDATED: How do i map access database on windows 2008 r2 64bit?

I am having a really hard time today in searching for a solution for mapping the access database file on windows server 2008 r2 64bit.

The issue at hand is that I cannot find the Microsoft Jet Engine drivers for the windows server 2008. I am not sure as to why there are no drivers easily available not just for odbc of access but for excel as well.

After I installed sql server I got the sql server drivers and I hoped that after installing the Microsoft office 2007 trial edition on the server, it will install the odbc drivers for both access and excel, but it does not seems to be the case.

now the dilemma is on how to find these drivers, how do I get the same kind of sys 32 drivers work on a sys 64 bit system and map the old access mdb files so that I can make the coldfusion application work.

Ok, i found a solution online as to what I was missing the knowledge of

Solution posted by kbjohnson:
Run the following file for 32bit ODBC mapping:


Popular posts from this blog

Working hours in six months to a year

I usually try to look for how many hours I have worked on a given project and what hours that I  spend on learning or network management tasks.

Below I have added some hours calculation, after finding the breakdown by months from Berkeley website.


2017Working hours six months (Jan 1st - Jun 30th): 
130 days x 8 hours =  1040 hours

Working hours six months (Jul 1st - Dec 31th): 
130 days x 8 hours =  1040 hours

Working hours for the year:
1040 hours + 1040 hours = 2080 hours
MonthWorking Days in the monthMonthly Working Hrs1/2 of working hrsMidpoint of working days in the monthDates of HolidaysJanuary22176888 a.m. 1/172,16February20160808 a.m. 2/1520March2318492Noon 3/1631April20160808 a.m. 4/17May2318492Noon 5/1629June22176888 a.m. 6/16July2116884Noon 7/174August2318492Noon 8/16September2116884Noon 9/154October22176888 a.m. 10/17November22176888 a.m. 11/1610,23,24December21168…