Back to the OP, in the event that somebody actually needs help...

If Access is prompting for a password, but there was no database password set - then the file cannot be repaired & you need to restore a backup.