WILLIAM MITCHELL (7/22/2014)
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.
Hence the importance of always having a backup strategy for your information, whether SQL Server or a personal PC.
----------------------------------------------------