Setting 2003 ULS permissions won't stick using 2007

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

Jacques Latoison

We have an MDB that is in the Access 2003 format. It uses User Level
Security and has worked well for some time.
After upgrading the staff with Access 2007, it still works fine.

I now need to make some permissions changes, and although 2007 will let me
view it, and change it on the screen, nothing actually sticks - it doesn't
actually do the work in the background, even though its doing it on the
screen.

Any suggestions are helpful...
 
We have an MDB that is in the Access 2003 format. It uses User Level
Security and has worked well for some time.
After upgrading the staff with Access 2007, it still works fine.

I now need to make some permissions changes, and although 2007 will let me
view it, and change it on the screen, nothing actually sticks - it doesn't
actually do the work in the background, even though its doing it on the
screen.

Any suggestions are helpful...
Click to expand...

Are you SURE that you're joined to the correct workgroup when making these changes? I'm not overly familiar with 2007,
but in 03 you would open Access and click Tools - Security - Workgroup Administrator ... or you can open your VB edit
window, then the Immediate window and type this:

?dbengine.systemdb

This would show the workgroup you're currently using ... make sure it's the correct workgroup.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Yes I'm sure.
The DB's are opened with a shortcut that uses that workgroup.
The DB's are not opened by clicking directly on the DB's themselves.

There are several DB's that use the same workgroup, and its the only
workgroup file on the network.
 
Could you be more specific. What makes you think the permission changes are not sticking? Remember that the permissions are stored in the mdb file. Once you make permission changes, you need to distribute the updated frontend to the users.

Only the usernames/passwords/groups/memberships are stored in the common mdw.
 
When I go back into the permissions window, after completely leaving it,
they aren't changed.
When I had to give someone access to something, it would never work.
When I checked it from an older machine running Access 2003, it wasn't
changed.
When I changed it from that Access 2003 machine, it worked.


Could you be more specific. What makes you think the permission changes are
not sticking? Remember that the permissions are stored in the mdb file.
Once you make permission changes, you need to distribute the updated
frontend to the users.

Only the usernames/passwords/groups/memberships are stored in the common
mdw.
 
Back
Top