Super User Asked on December 23, 2021
I need to edit an MS Access database. It’s split into 2 parts.
I can open the 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 are this:
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.
More details:
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?
Currently, I am developing and Access application in which I need to do the same thing you are currently trying to do. In my research, I have found that in order to secure your front end you must simulate a login instead of adding a password to the file itself. You can do this by adding a couple tables and a pop form with some VBA. This will allow you to not only have multiple users but logs for said users.
Also, your database may be locked because it is already open else where. For each user you have, they should have a copy of the front end connected to the backend on a networked drive.
Answered by Casey Spires on December 23, 2021
Have you tried holding down the shift key while opening the database? This basically allows the database to bypass any startup options that might be blocking you from editing the database.
Answered by Geoff on December 23, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP