Password Protect Issue - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Password Protect Issue

Lee Shastid

16 months ago

I created a Database that has been working fine and no issues. I decided to password protect it. After doing such, I can not get back into it now. After I put in my password I get the following language in a dialog box. "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." I am fine at this point with no password if I can get back into it. Microsoft support said it was something wrong with a file and said go get help elsewhere.

	Bill Carver @Reply 16 months ago
How long ago did you password protect it? Do you have a backup of the database just before you did that?

	Lee Shastid OP @Reply 16 months ago
Just password protected it last night before I posted this. And of course I made the mistake of not backing it up.

	Kevin Robertson @Reply 16 months ago
Try creating a new database and import all your objects from your old database to the new one. Do you still get the error message after typing in your password? Import Objects

	Lee Shastid OP @Reply 16 months ago
I am not sure how to do the import you are speaking of. When I type my password it acts like it actually lets me in and immediately get that message. Microsoft support said the same thing basically it was with a file because it look like it was letting me in.

	Bill Carver @Reply 16 months ago
Is where the access file stored by any chance synced to OneDrive?

	Lee Shastid OP @Reply 16 months ago
Kevin I tried that way and it does the same thing. It acts like it accepts my password but something is stopping me from accessing anything. Bill it was not synced with OneDrive. I dont use One drive.

	Bill Carver @Reply 16 months ago
What Halle s if you right click the file and try to restore previous versions.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View