User level security 2002 / 2003

[Cfox4]

I've got an XP2002 db that I secured via user level security. My
problem is that my XP2003 users cannot open forms. They get the error
"you do not have open/run priveleges on form"

I've had those same 2003 users log into the db on a 2002 machine and
they are able to open the forms. Is there a file format issue here?
Any ideas? .mdw compatibility issues?

 

[Rick Brandt]

I've got an XP2002 db that I secured via user level security. My
problem is that my XP2003 users cannot open forms. They get the error
"you do not have open/run priveleges on form"

I've had those same 2003 users log into the db on a 2002 machine and
they are able to open the forms. Is there a file format issue here?
Any ideas? .mdw compatibility issues?

Are they using your secured workgroup (MDW) file? If not, then your actual
problem is that you didn't apply security properly in the first place. Usually
this would result in no security at all, but in your case the security "hole" is
only letting then into the file, but is at least stopping them at the forms.

One of the more common mistakes when applying security is leaving "Admin" as the
owner of the database and some or all of the objects. As owner Admin will be
allowed in even though he has no "permissions". Any objects that you created
after securing the file would not be owned by Admin so someone opening the file
with the wrong workgroup would not be able to use those objects.

You should start over with your security until you achieve the proper behavior
which is that someone using the wrong workgroup is not able to open the file at
all. Then you can give all users a shortcut for your file that specifies the
correct workgroup as a command line argument. Using that shortcut they would be
prompted to log in and should be granted the permissions assigned to the account
they use.

 

[Cfox4]

Thanks for the response. Yes they are using the same workgroup file. I've
even changed the owner of my start up form to be the group that these guys
belong to.

I've made shortcuts for both Access2002 and 2003 since 2002's access.exe is
in office10 and 2003 in office11. Both shortcuts use the same /wrkgrp switch
and path is exactly the same to the wrkgrp.

The original unsecured db was in 2000 file format and I notice that the mdw
is also 2000 format. I wouldn't think this would be an issue but it's
possible I guess.

The thing I find interesting is that the any user who has Access 2003
installed on their machine can go to a machine with Access 2002 on it and log
in successfully.

This would indicate that the issue is related to 2003. Any other thoughts
or suggestions??? Thanks

 

[Rick Brandt]

Thanks for the response. Yes they are using the same workgroup
file. I've even changed the owner of my start up form to be the
group that these guys belong to.

I've made shortcuts for both Access2002 and 2003 since 2002's
access.exe is in office10 and 2003 in office11. Both shortcuts use
the same /wrkgrp switch and path is exactly the same to the wrkgrp.

The original unsecured db was in 2000 file format and I notice that
the mdw is also 2000 format. I wouldn't think this would be an issue
but it's possible I guess.

The thing I find interesting is that the any user who has Access 2003
installed on their machine can go to a machine with Access 2002 on it
and log in successfully.

This would indicate that the issue is related to 2003. Any other
thoughts or suggestions??? Thanks

You could try converting your MDW to 2002/2003 format (a separate copy of
course) and then see if the users with 2003 can use that.