I too am using Access 2007 but on Windows 7.
I was able to assign a transparent do it was create a real icon file (not a renamed BMP).
I used an export plugin for Photoshop or just save to .ico from Gimp.
I tested the following setting in Gimp
Make sure you add an alpha layer, then save as ico...