Associate
- Joined
- 15 Jun 2009
- Posts
- 2,494
I have created a relatively simple access database to track work we do, Currently I've got it in runtime mode and just locked it down, Opening pretty much everything in read only mode apart from where necessary.
Problem here is when I need to amend a record, Taking it out of runtime mode and re-opening it, Amending the record and then putting it back into runtime mode.
Is there any way to have a certain button or anything that will open the table in full access mode for me to edit but put a password. Even a bodge job would do, Was thinking maybe have a form with a text box, If the correct 'password' was entered it would then open the table?
Any ideas?
TL;DR - Best way to lock down an access database but keep an 'admin' mode to edit records?
Problem here is when I need to amend a record, Taking it out of runtime mode and re-opening it, Amending the record and then putting it back into runtime mode.
Is there any way to have a certain button or anything that will open the table in full access mode for me to edit but put a password. Even a bodge job would do, Was thinking maybe have a form with a text box, If the correct 'password' was entered it would then open the table?
Any ideas?
TL;DR - Best way to lock down an access database but keep an 'admin' mode to edit records?