Permissions Error When There Shouldn't Be One

[Guest]

I have several Access 2003 databases that are all occasionally giving me the
same problem. For no apparent reason, a user (sometimes me, sometimes
someone else) will get a message telling them that they do not have
permission to use a query or table. Yet when I check their permissions in my
User & Group Permissions, it shows that they have full Admin privileges for
the same query or table. This has happened to me multiple times with queries
I created in databases I designed. Any idea what could be causing this and
how to stop it?

 

['69 Camaro]

Hi, Amy.

For no apparent reason, a user (sometimes me, sometimes
someone else) will get a message telling them that they do not have
permission to use a query or table. Yet when I check their permissions in
my
User & Group Permissions, it shows that they have full Admin privileges
for
the same query or table.

This happens quite often when the developer is checking the permissions in
the development version of the database, not the version the users are using
in production. In the development version, the permissions exist, but in
the older production version, the newly assigned permissions don't.

Ensure that a copy of your development version front end is distributed to
every user when it's ready, and that every user is using the updated copy,
and that everyone is pointing to the correct workgroup information file to
join to when opening the secure database. If you're using a different
workgroup information file during development, ensure that any new users,
new groups, and group membership for the users propogates to the production
version of the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.