Hi everyone and thanks in advance for any assistance.
Here is my situation - I left an area which I had made a database for them to track information in. The person whom I handed the database over to decided it was a good idea to tell the users that they can hold down shift when they open the database to go in as an administrator. As you can probably guess the end users are now entering data directly into the tables, bypassing the forms I had set up and the edits on the form. This has led to some bad/invalid data being entered into the tables. Someone also somehow managed to either delete/move the database entirely. I received a call saying that the database had dissappeared the other day - thankfully our IS staff was able to recover from last week so not all was lost.
So now my question - what I am currently planning on doing for them is to split the database and put the back end in an out of the way folder, and hiding everthing in the front end so even if the users do open with the shift key nothing will be shown.
What I would also like to do if possible is to simply disable the shift key when opening - is there a way to do that, and if so how do you get in as an administrator afterwards?
Since I am not in that area any more I can't dedicate a lot of time to helping them out and am looking for any other suggestions I can use to make sure that the users have to enter through the entry forms and prevent them from deleting the database again.
This database is on a network drive in a folder that only employees of that division can access.
Thanks for any help and let me know if any additional information is needed.
Here is my situation - I left an area which I had made a database for them to track information in. The person whom I handed the database over to decided it was a good idea to tell the users that they can hold down shift when they open the database to go in as an administrator. As you can probably guess the end users are now entering data directly into the tables, bypassing the forms I had set up and the edits on the form. This has led to some bad/invalid data being entered into the tables. Someone also somehow managed to either delete/move the database entirely. I received a call saying that the database had dissappeared the other day - thankfully our IS staff was able to recover from last week so not all was lost.
So now my question - what I am currently planning on doing for them is to split the database and put the back end in an out of the way folder, and hiding everthing in the front end so even if the users do open with the shift key nothing will be shown.
What I would also like to do if possible is to simply disable the shift key when opening - is there a way to do that, and if so how do you get in as an administrator afterwards?
Since I am not in that area any more I can't dedicate a lot of time to helping them out and am looking for any other suggestions I can use to make sure that the users have to enter through the entry forms and prevent them from deleting the database again.
This database is on a network drive in a folder that only employees of that division can access.
Thanks for any help and let me know if any additional information is needed.