roland_access
Registered User.
- Local time
- Today, 21:40
- Joined
- Feb 13, 2002
- Messages
- 35
Have set up database security fully and properly. What I need to do now is stop users from closing forms and editing data directly from the underlying tables. They must only be able to edit data via forms.
I have set permissions for the users so that they cannot view forms in design view. I have also disabled Access Special Keys and the Shift bypass on start up.
Now onto the forms themselves. What I have at the moment is a Pop Up and Modal form with no control box (no minimize, maximize or close buttons). This, coupled with them not being able to view the design means they cannot get "behind" this form to the tables.
All this is fine, apart from of course they need to be able to go back to their desktop now and then without closing the database. I have tried a few things; calling the Quick Launch shortcut from a command button causes an Office confirmation message. Enabling Windows' Quick Launch toolbar and educating users on its View Desktop shortcut seems crude.
I have spent a lot of time with the MS Security FAQ, but could not get the code to work that deals with changing a groups table permissions when closing a form.
Another thing, when you are using a pop up form and minimize the database, often when restoring the database the form is not maximized, even if a DoCmd.Maximize is used somewhere on that form.
Any ideas please?
I have set permissions for the users so that they cannot view forms in design view. I have also disabled Access Special Keys and the Shift bypass on start up.
Now onto the forms themselves. What I have at the moment is a Pop Up and Modal form with no control box (no minimize, maximize or close buttons). This, coupled with them not being able to view the design means they cannot get "behind" this form to the tables.
All this is fine, apart from of course they need to be able to go back to their desktop now and then without closing the database. I have tried a few things; calling the Quick Launch shortcut from a command button causes an Office confirmation message. Enabling Windows' Quick Launch toolbar and educating users on its View Desktop shortcut seems crude.
I have spent a lot of time with the MS Security FAQ, but could not get the code to work that deals with changing a groups table permissions when closing a form.
Another thing, when you are using a pop up form and minimize the database, often when restoring the database the form is not maximized, even if a DoCmd.Maximize is used somewhere on that form.
Any ideas please?
Last edited: