Hi Folks,
I am trying to lock down a MS Access front end that links to a SQL Server back end. I have a Autoexec running at open of database that pretty much prevents the user from doing anything that I don't want them to do, I disabled the ribbon and all the menus and pretty much everything else, I even disabled the shift bypass key. There is a password on the database but that is for the proper user to be allowed to enter data into the databases. I even went so far as to disable the close buttons and overriding them so that when the user closes a form (and all forms automatically maximize), the splash screen comes up.
What I cannot seem to do is prevent someone from importing the database objects into a new Access database. If a user did this, nothing is stopping them except a database password that they would have anyway. Is there a way to prevent these database objects to be imported into a new file? And on a similar token, if anyone can think of something that I missed in terms of forcing the data entry folks to only have access to what they need and only that or other security measures I can easily take, please let me know. Also, if there happens to be an 'error' with this database, which should be unlikely because it is so locked down ... you know, one of those errors where you click debug and can see everything ... I would just want the app to immediately close out or do nothing as opposed to the user being able to view anything they shouldn't ... any ideas?
Thank you,
Joe
I am trying to lock down a MS Access front end that links to a SQL Server back end. I have a Autoexec running at open of database that pretty much prevents the user from doing anything that I don't want them to do, I disabled the ribbon and all the menus and pretty much everything else, I even disabled the shift bypass key. There is a password on the database but that is for the proper user to be allowed to enter data into the databases. I even went so far as to disable the close buttons and overriding them so that when the user closes a form (and all forms automatically maximize), the splash screen comes up.
What I cannot seem to do is prevent someone from importing the database objects into a new Access database. If a user did this, nothing is stopping them except a database password that they would have anyway. Is there a way to prevent these database objects to be imported into a new file? And on a similar token, if anyone can think of something that I missed in terms of forcing the data entry folks to only have access to what they need and only that or other security measures I can easily take, please let me know. Also, if there happens to be an 'error' with this database, which should be unlikely because it is so locked down ... you know, one of those errors where you click debug and can see everything ... I would just want the app to immediately close out or do nothing as opposed to the user being able to view anything they shouldn't ... any ideas?
Thank you,
Joe
