Hi, sorry if this has been asked before but i've been searching around and haven't found a solution (or cause) for my problem:
I have a database in 2010 that which I assigned a password to as normal (i may have been using a comp w/ 2007 Access when i assigned the pw, i honestly don't remember, regardless the file type is .accdb). It works fine to log in, view all design windows, write code, create and edit anything i wish, and in general - works like it should.
However
- I cannot remove the password - the option just isn't there to do it. I do not have any settings for the ribbon and am not running any code that would affect startup in anyway (at least i didn't write any). There is an option to encrypt the database, but the current working password does not work, nor a new password, nor just a blank password - it always says 'Not a valid password'.
- I also cannot compact the database. It is not set to compact on close (although at one point i may have set it to that and then turned it back off). When i choose the compact option, it asks for the password three times and then always says 'Not a valid password'.
I've tried holding shift down on startup and/or opening in exclusive mode but both of the above problems persist. I can copy all the objects out of the database into a new one (i've tried this and can assign/remove a password and compact as normal); however i'm leary about spending the time reassigning all the relationships and such because i don't know what i did to break the database in the first place. The database has been built/used over a few different computers (started with it 1 month ago), however all of my backups seem to have these same issues.
Anyone have suggestions on how to fix (or more importantly - avoid) this problem?