Let $R$ be a commutative ring and let $M,N$ be free modules over $R$ and suppose we have a map $f: M \rightarrow N$ such that upon taking $\text{ Hom}(-,R)$ we get an isomorphism $f^* : N^* \rightarrow M^*.$ Must $f$ be an isomorphism as well?
This is clear if $M,N$ are free and of finite dimension, since then double dualization can be applied. But in general, what is true?
Edit. In the comments egreg has sketched an example which seems fine. This seems to involve cardinality issues, so what happens if I assume that $M$ and $N$ are both countably generated?
Let $R=\mathbb{Z}_p$, the $p$-adic integers, and let $M=N$ be countably generated free modules. We can regard elements of $M$ as finite sequences of $p$-adic integers, and elements of $M^*$ as arbitrary sequences of $p$-adic integers.
Let $f$ be the map $$(a_0,a_1,a_2,\dots)\mapsto(a_0,-pa_0+a_1,-pa_1+a_2,\dots),$$ so that $f^*$ is the map $$(b_0,b_1,b_2,\dots)\mapsto(b_0-pb_1,b_1-pb_2,b_2-pb_3\dots).$$
Then $f$ is not invertible, since $(1,0,0\dots)$ is not in the image.
But $f^*$ is invertible, with inverse $$(c_0,c_1,c_2,\dots)\mapsto(c_0+pc_1+p^2c_2+\dots,\text{ } c_1+pc_2+p^2c_3+\dots,\text{ } c_2+pc_3+p^2c_4+\dots,\text{ }\dots).$$