Equivalences between categories of modules and categories of comodules