|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Form Permissions DisappearI followed Joan Wild's instructions on securing the database and it worked fine. I tested and all is secure. I added additional users when using the User Level Security Wizard. Now I would like to assign permissions to the users. I have used the desktop shortcut to open my secured db, using my AdminUser name and password. I then created a group called DataEntry and assigned this group to each of my users. I then set the permissions for DataEntry to be such that they can open the database, read, add, edit, delete table records, open forms, and so on. Each time I do this and then log off and back on as one of the users, and try to open a form for data entry, it tells me that I don't have permission. I then log back in as the AdminUser and re-check the permission of the DataEntry group and find that form permissions have been removed. My questions are: 1. What am I doing wrong in this case. 2. Do I re-run the User Level Security Wizard each time I wish to add a new user to my db? Thanks so much. I've learned a TON here! -- Thanks! Dee I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form?
The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. -- Joan Wild Microsoft Access MVP Show quote "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... >I am obviously doing something wrong here. Help! :-) > > I followed Joan Wild's instructions on securing the database and it worked > fine. I tested and all is secure. > > I added additional users when using the User Level Security Wizard. > > Now I would like to assign permissions to the users. > > I have used the desktop shortcut to open my secured db, using my AdminUser > name and password. I then created a group called DataEntry and assigned this > group to each of my users. I then set the permissions for DataEntry to be > such that they can open the database, read, add, edit, delete table records, > open forms, and so on. > > Each time I do this and then log off and back on as one of the users, and > try to open a form for data entry, it tells me that I don't have permission. > I then log back in as the AdminUser and re-check the permission of the > DataEntry group and find that form permissions have been removed. > > My questions are: > > 1. What am I doing wrong in this case. > 2. Do I re-run the User Level Security Wizard each time I wish to add a new > user to my db? > > Thanks so much. I've learned a TON here! > -- > Thanks! > > Dee Hi Joan,
Thanks for your response. I tried the same thing on a different database and on a different computer and the same thing happened. I've checked my options and can't see why this would happen. I will start another db from scratch and try it again. It's just weird that I can set the forms permissions, but when I exit the db and log in again using another user name and password, I am denied access to form and when I check the permissions - they are removed. A couple of questions: 1. Have you ever heard of my problem of a desktop shortcut to the secured db not being automatically generated when running the wizard? It seemed that when I saved the mdw file in the default directly, it did create the shortcut, but when I saved in another one, it didn't. I should mention that my db is on a D drive, which is where I also am trying to save the mdw file. 2. Am I correct in re-running the User-Level Security wizard each time I add a new user? Thanks for your help. -- Thanks! Dee Show quote "Joan Wild" wrote: > I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form? > > The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. > > -- > Joan Wild > Microsoft Access MVP > "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... > >I am obviously doing something wrong here. Help! :-) > > > > I followed Joan Wild's instructions on securing the database and it worked > > fine. I tested and all is secure. > > > > I added additional users when using the User Level Security Wizard. > > > > Now I would like to assign permissions to the users. > > > > I have used the desktop shortcut to open my secured db, using my AdminUser > > name and password. I then created a group called DataEntry and assigned this > > group to each of my users. I then set the permissions for DataEntry to be > > such that they can open the database, read, add, edit, delete table records, > > open forms, and so on. > > > > Each time I do this and then log off and back on as one of the users, and > > try to open a form for data entry, it tells me that I don't have permission. > > I then log back in as the AdminUser and re-check the permission of the > > DataEntry group and find that form permissions have been removed. > > > > My questions are: > > > > 1. What am I doing wrong in this case. > > 2. Do I re-run the User Level Security Wizard each time I wish to add a new > > user to my db? > > > > Thanks so much. I've learned a TON here! > > -- > > Thanks! > > > > Dee > Are you also setting permissions for the recordsource of the form (and the rowsources for combo/listboxes)?
I believe that during the wizard process, you can choose not to create a desktop shortcut. I wouldn't rerun the wizard every time, no. Just use the Security menu items. In fact this may be causing your problem, I'm not sure. If you don't have the permissions checked that you had previously, it may be removing that permission. -- Joan Wild Microsoft Access MVP Show quote "dee" <d**@discussions.microsoft.com> wrote in message news:1E9D0769-2902-4956-BC7C-85F3F9CADA55@microsoft.com... > Hi Joan, > > Thanks for your response. I tried the same thing on a different database > and on a different computer and the same thing happened. > > I've checked my options and can't see why this would happen. I will start > another db from scratch and try it again. It's just weird that I can set the > forms permissions, but when I exit the db and log in again using another user > name and password, I am denied access to form and when I check the > permissions - they are removed. > > A couple of questions: > > 1. Have you ever heard of my problem of a desktop shortcut to the secured > db not being automatically generated when running the wizard? It seemed that > when I saved the mdw file in the default directly, it did create the > shortcut, but when I saved in another one, it didn't. I should mention that > my db is on a D drive, which is where I also am trying to save the mdw file. > 2. Am I correct in re-running the User-Level Security wizard each time I > add a new user? > > Thanks for your help. > -- > Thanks! > > Dee > > > "Joan Wild" wrote: > >> I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form? >> >> The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... >> >I am obviously doing something wrong here. Help! :-) >> > >> > I followed Joan Wild's instructions on securing the database and it worked >> > fine. I tested and all is secure. >> > >> > I added additional users when using the User Level Security Wizard. >> > >> > Now I would like to assign permissions to the users. >> > >> > I have used the desktop shortcut to open my secured db, using my AdminUser >> > name and password. I then created a group called DataEntry and assigned this >> > group to each of my users. I then set the permissions for DataEntry to be >> > such that they can open the database, read, add, edit, delete table records, >> > open forms, and so on. >> > >> > Each time I do this and then log off and back on as one of the users, and >> > try to open a form for data entry, it tells me that I don't have permission. >> > I then log back in as the AdminUser and re-check the permission of the >> > DataEntry group and find that form permissions have been removed. >> > >> > My questions are: >> > >> > 1. What am I doing wrong in this case. >> > 2. Do I re-run the User Level Security Wizard each time I wish to add a new >> > user to my db? >> > >> > Thanks so much. I've learned a TON here! >> > -- >> > Thanks! >> > >> > Dee >> Hi Joan,
I'm using Acess 2003 - I don't recall seeing anything that would give me the choice or not of creating the desktop shortcut. How do I set the permissions for the form and combo box record sources? I have tested a bunch of new fictitious databases for this and even when run the Wizard only once. I add new user(s) during the Wizard process and then assign them to a newly created group after having run the Wizard. I have double-checked the permissions before closing the db and they are still there. I then exit and, using the desktop shortcut, log back in under one of the new users, but when I try to open a form it indicates that I don't have access rights. When I log back in as the Admin user, and check the permissions, they are no longer there. If, however, I select a built-in group, create new users and asign them to the built in group during the Wizard process, no problem at all. When you say I can just use the Security menu to add new users, if I understand correctly, I will add the user name and ID, assign them to a group, then log off and back on using their name, after which I will be able to add a password? Also, how do I secure a db manually? Perhaps if I go through the process, I will better understand what is happening. Thanks so much! -- Thanks! Dee Show quote "Joan Wild" wrote: > Are you also setting permissions for the recordsource of the form (and the rowsources for combo/listboxes)? > > I believe that during the wizard process, you can choose not to create a desktop shortcut. > > I wouldn't rerun the wizard every time, no. Just use the Security menu items. In fact this may be causing your problem, I'm not sure. If you don't have the permissions checked that you had previously, it may be removing that permission. > > > -- > Joan Wild > Microsoft Access MVP > "dee" <d**@discussions.microsoft.com> wrote in message news:1E9D0769-2902-4956-BC7C-85F3F9CADA55@microsoft.com... > > Hi Joan, > > > > Thanks for your response. I tried the same thing on a different database > > and on a different computer and the same thing happened. > > > > I've checked my options and can't see why this would happen. I will start > > another db from scratch and try it again. It's just weird that I can set the > > forms permissions, but when I exit the db and log in again using another user > > name and password, I am denied access to form and when I check the > > permissions - they are removed. > > > > A couple of questions: > > > > 1. Have you ever heard of my problem of a desktop shortcut to the secured > > db not being automatically generated when running the wizard? It seemed that > > when I saved the mdw file in the default directly, it did create the > > shortcut, but when I saved in another one, it didn't. I should mention that > > my db is on a D drive, which is where I also am trying to save the mdw file. > > 2. Am I correct in re-running the User-Level Security wizard each time I > > add a new user? > > > > Thanks for your help. > > -- > > Thanks! > > > > Dee > > > > > > "Joan Wild" wrote: > > > >> I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form? > >> > >> The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... > >> >I am obviously doing something wrong here. Help! :-) > >> > > >> > I followed Joan Wild's instructions on securing the database and it worked > >> > fine. I tested and all is secure. > >> > > >> > I added additional users when using the User Level Security Wizard. > >> > > >> > Now I would like to assign permissions to the users. > >> > > >> > I have used the desktop shortcut to open my secured db, using my AdminUser > >> > name and password. I then created a group called DataEntry and assigned this > >> > group to each of my users. I then set the permissions for DataEntry to be > >> > such that they can open the database, read, add, edit, delete table records, > >> > open forms, and so on. > >> > > >> > Each time I do this and then log off and back on as one of the users, and > >> > try to open a form for data entry, it tells me that I don't have permission. > >> > I then log back in as the AdminUser and re-check the permission of the > >> > DataEntry group and find that form permissions have been removed. > >> > > >> > My questions are: > >> > > >> > 1. What am I doing wrong in this case. > >> > 2. Do I re-run the User Level Security Wizard each time I wish to add a new > >> > user to my db? > >> > > >> > Thanks so much. I've learned a TON here! > >> > -- > >> > Thanks! > >> > > >> > Dee > >> > As a follow-up, I have been testing this all morning, and have found that if
I create a new group myself, set permissions to group and add users to the group, the permissions "disappear". If, however, I select a "built-in" group when running the User Level Security Wizard and assign users to that group - no problem. -- Thanks! Dee Show quote "Joan Wild" wrote: > I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form? > > The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. > > -- > Joan Wild > Microsoft Access MVP > "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... > >I am obviously doing something wrong here. Help! :-) > > > > I followed Joan Wild's instructions on securing the database and it worked > > fine. I tested and all is secure. > > > > I added additional users when using the User Level Security Wizard. > > > > Now I would like to assign permissions to the users. > > > > I have used the desktop shortcut to open my secured db, using my AdminUser > > name and password. I then created a group called DataEntry and assigned this > > group to each of my users. I then set the permissions for DataEntry to be > > such that they can open the database, read, add, edit, delete table records, > > open forms, and so on. > > > > Each time I do this and then log off and back on as one of the users, and > > try to open a form for data entry, it tells me that I don't have permission. > > I then log back in as the AdminUser and re-check the permission of the > > DataEntry group and find that form permissions have been removed. > > > > My questions are: > > > > 1. What am I doing wrong in this case. > > 2. Do I re-run the User Level Security Wizard each time I wish to add a new > > user to my db? > > > > Thanks so much. I've learned a TON here! > > -- > > Thanks! > > > > Dee > I think you are having this problem because you're repeatedly running the wizard.
By the way, you can secure a database without using the wizard. -- Joan Wild Microsoft Access MVP Show quote "dee" <d**@discussions.microsoft.com> wrote in message news:7C8284C8-A4FA-44E3-B0AC-C8EAF52AAE38@microsoft.com... > As a follow-up, I have been testing this all morning, and have found that if > I create a new group myself, set permissions to group and add users to the > group, the permissions "disappear". > > If, however, I select a "built-in" group when running the User Level > Security Wizard and assign users to that group - no problem. > > > -- > Thanks! > > Dee > > > "Joan Wild" wrote: > >> I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form? >> >> The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... >> >I am obviously doing something wrong here. Help! :-) >> > >> > I followed Joan Wild's instructions on securing the database and it worked >> > fine. I tested and all is secure. >> > >> > I added additional users when using the User Level Security Wizard. >> > >> > Now I would like to assign permissions to the users. >> > >> > I have used the desktop shortcut to open my secured db, using my AdminUser >> > name and password. I then created a group called DataEntry and assigned this >> > group to each of my users. I then set the permissions for DataEntry to be >> > such that they can open the database, read, add, edit, delete table records, >> > open forms, and so on. >> > >> > Each time I do this and then log off and back on as one of the users, and >> > try to open a form for data entry, it tells me that I don't have permission. >> > I then log back in as the AdminUser and re-check the permission of the >> > DataEntry group and find that form permissions have been removed. >> > >> > My questions are: >> > >> > 1. What am I doing wrong in this case. >> > 2. Do I re-run the User Level Security Wizard each time I wish to add a new >> > user to my db? >> > >> > Thanks so much. I've learned a TON here! >> > -- >> > Thanks! >> > >> > Dee >> OK, I'm going to scrape the egg off of my face :-)
I realized what I was doing wrong... knew it was probably something I was doing... when creating the groups and assigning permissions, as soon as I selected the Database and gave permission, them selected the Table object, the New Tables option was selected, but not the existing tables - they were deselected after having selected the Database and I didn't notice. I won't forget that ever again! On the other hand, I'm still wondering why, if I run the Wizard and don't select the default folder where the system.mdw is stored, but select another folder on another drive as the destination, a shortcut isn't created. If I save it in the default folder - no problem - shortcut gets created. I also don't know that I'm totally clear on what's going on behind the scenes when running the Wizard. I was under the impression that it modified the joined mdw to include new users, but if I can just add new ones later, I guess that's not the case? Thanks again and apologies for my stupidity! :-) -- Thanks! Dee Show quote "Joan Wild" wrote: > I think you are having this problem because you're repeatedly running the wizard. > > By the way, you can secure a database without using the wizard. > > -- > Joan Wild > Microsoft Access MVP > "dee" <d**@discussions.microsoft.com> wrote in message news:7C8284C8-A4FA-44E3-B0AC-C8EAF52AAE38@microsoft.com... > > As a follow-up, I have been testing this all morning, and have found that if > > I create a new group myself, set permissions to group and add users to the > > group, the permissions "disappear". > > > > If, however, I select a "built-in" group when running the User Level > > Security Wizard and assign users to that group - no problem. > > > > > > -- > > Thanks! > > > > Dee > > > > > > "Joan Wild" wrote: > > > >> I don't see anything wrong from your description. Are you certain you are assigning Open permission on the form? > >> > >> The only way the permissions could be removed is if you import an object (the permissions don't travel with it), or you did so in code. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "dee" <d**@discussions.microsoft.com> wrote in message news:A17E25FC-63BD-4D7B-99A9-C3B9B0E74A83@microsoft.com... > >> >I am obviously doing something wrong here. Help! :-) > >> > > >> > I followed Joan Wild's instructions on securing the database and it worked > >> > fine. I tested and all is secure. > >> > > >> > I added additional users when using the User Level Security Wizard. > >> > > >> > Now I would like to assign permissions to the users. > >> > > >> > I have used the desktop shortcut to open my secured db, using my AdminUser > >> > name and password. I then created a group called DataEntry and assigned this > >> > group to each of my users. I then set the permissions for DataEntry to be > >> > such that they can open the database, read, add, edit, delete table records, > >> > open forms, and so on. > >> > > >> > Each time I do this and then log off and back on as one of the users, and > >> > try to open a form for data entry, it tells me that I don't have permission. > >> > I then log back in as the AdminUser and re-check the permission of the > >> > DataEntry group and find that form permissions have been removed. > >> > > >> > My questions are: > >> > > >> > 1. What am I doing wrong in this case. > >> > 2. Do I re-run the User Level Security Wizard each time I wish to add a new > >> > user to my db? > >> > > >> > Thanks so much. I've learned a TON here! > >> > -- > >> > Thanks! > >> > > >> > Dee > >> >  |
|||||||||||||||||||||||
Other interesting topics