Access - Stop users editing

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?
 
Right, Found if I just have a form with a text box and a button. Using a macro I can make it so if the correct password is entered, It will open the table with read & write access, If not it will display an error message.

Will do me for now.
 
Back
Top Bottom