When developing a COM add in for Access 2010 (and other MS Office products I suspect), when using regasm to register the DLL, throw both the TLB and the CODEBASE flags
Otherwise Access gets lost, and you get automation errors on referencing the COM objects the DLL supports