What type of database is this, mdb or accde? Are you using uls?
Did you encrypt the database in the first place?
Do you have the full version of Access or just runtime?
What is your current Access build no.?
Could they prompt be to enter s password for your backend, hence why you don't have the option in your front-end? What type of backend are you using?