Form Permissions Disappear

[dee]

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!

 

[Joan Wild]

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.

 

[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

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.

 

[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

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]

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

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.

 

[Joan Wild]

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

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.

 

[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!

 

[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!