I'm using sql 2000 and Access 2003. I have a Maintnenace adp
database w/ tblMaintenance and 2 queries qryMaintEntry and
qryMaintDept.
I have 2 groups AllUsers and Maint. The people in the Maint group
are also part of the AllUsers.
There are no permissions set to the table. The qry MaintEntry has
AllUsers permissions set to Select, Insert and Update.
The qryMaintDept has Maint only permission set to Select, Insert,
Update and Delete.
The problem I'm having is everyone has full control over the entire
database. I've tried denying permissions to the AllUser in the
qryMaintDept but then the AllUsers are denied access to any part of
the database.
No matter what I do the AllUsers group either has full access or no
access.
Does anyone have any idea what I need to do so the AllUsers can
access the qryMaintEntry and not the qryMaintEntry?
Thank for the help,
Paul
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/AccessVBACentral/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
