Security Permissions - Changes Reset!

[Guest]

This problem is making me crazy. I believe I have set up everything
properly. When I go in as an Administrator and change permissions for Full
Data Users, then sign on as one, temporarily everything seems to be fine,
access to objects in line with what I set up. Then, all of sudden, I don't
have permission to access a table that I just gave permission to, even though
I just had permission a minute ago. I go back in as an Administrator, and
see that every change I made was re-set back to where it was before! I
change permissions again, and the same thing continues to occur. All times
logging in under the same Workgroup.

Please help! Thank you!

 

[Joan Wild]

Permissions are stored in the mdb file, not the workgroup. Are you sure you
are opening the same mdb file each time?

Permissions do not change by themselves. If you are importing objects, the
permissions won't travel with the object. If you are creating tables via
make table queries, permissions on this object will be determined by the
permissions on <New tables/queries>.

 

['69 Camaro]

Hi.

All times
logging in under the same Workgroup.

.. . . but you're opening a different database file than the one you set the
permissions on.

When I go in as an Administrator and change permissions for Full
Data Users, then sign on as one, temporarily everything seems to be fine,
access to objects in line with what I set up. Then, all of sudden, I
don't
have permission to access a table that I just gave permission to

Only members of the Admins group should have permissions on the tables. All
other groups may have permissions on the RWOP (run with owner's permissions)
queries in order to use the data in the tables.

I go back in as an Administrator, and
see that every change I made was re-set back to where it was before!

You're examining a different database file than the one you set the
permissions on earlier. I'd start troubleshooting the confusion by
guaranteeing that the database file and workgroup file I was setting
permissions on/with were the same by using a Windows shortcut for both users
opening the database file. Use the following syntax for the shortcut's
target (all one line):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW"

HTH.
Gunny

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

 

[Guest]

That's the answer! The tables that are being reset are the result of
make-table queries. Thank you so very much!

 

[Guest]

Thanks for the input! Joan Wild gave the right answer.