Personally, I think you are on the right track. I would use DBI, because it means that later when your boss decides he wants to use Oracle or something else instead, You can use the code you wrote for the Access script for the Oracle project.

Your other alternative could be Win32::ODBC, but why limit yourself?