I need to edit an MS Access database. It's split into 2 parts.
- database.accdb which has a password and shows me the front end
- database-be.accdb which is the back end and shows me the tables
I can open front end file in Access and it accepts the password. However, I don't see any of the menus and options that I'm used to seeing when opening MS Access database. I can use it fine, but I can not make any changes to the front end forms. The only thing I have as far as menu options is this:
- File (only Print, Privacy Options and Exit)
Nothing more. I'm assuming that even though it accepted my password it's locked somehow. How do I unlock it?
According to what I've been reading, there is a way to compile and lock down the front end. But that doesn't add up. If it was locked, I'd expect the file to be called .accde.
- Access 2010
- BE file size approx 2 MB
- FE file size approx 6 MB
The more I think about it, there must be a 3rd file that I'm missing - FE source file. Or am I just not understanding how this fits together?