Hello Everyone,
This is my first post here and I'm still learning Access "behind the scenes" workings, but I am a quick learner!
My company has an Access 2007.accdb database that we use to store client information and specifications. We then use word document merges to pull information into letter, notices, etc.
We are on a shared server and have the "main" database file on the server, with the tables separate/linked in another database on that same server. Each of use who updates information in the database has a copy on our desktop we use to update. We have been having issues recently with people accidentally changing/deleting information (how someone can 'accidentally' delete an entire client is beyond me... there are prompts to prevent that). We have people who are going into the database for information (i.e. to look up a phone number, or address, etc.) and we are trying to stop that, but some people just don't listen... so anyway we want something to prevent changes unless we really did mean to make said changes.
Is there a way to protect a form so that it can not be edited/deleted, but it is easy to say "yes I really do want to change that", possibly to have a prompt pop up and if we would like to remove the protection so we can edit we can do that? Maybe even a password required after said prompt?
We basically just want a fail safe there so that if people are looking around for information (even though they shouldn't be) they can't accidentally mess something up.
I hope that all made sense.
Any help is greatly appreciated.
-Ashley