Had same problem (strangely could view the attachment page when logged in as admin). Discovered that problem was in the database. post_parent was set to a non existent post id (-1179608178 when should have been 22!). Must be a bug when adding attachment.
