Re: User level security 2002 / 2003
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Fri, 07 Jul 2006 11:28:42 GMT
Cfox4 wrote:
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.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- Prev by Date: Re: Windows UserID and Access
- Next by Date: Re: How Do I Prevent Access 2003 Crash when using Digital ID & Lib
- Previous by thread: Re: Design Master security
- Next by thread: Re: User level security 2002 / 2003
- Index(es):
Relevant Pages
|
