Front-End User and Group Permissions not updating

[Telecom]

I recently created a new database and new workgroup file in Access 2003. I took all my old tables, queues, forms, etc from my old Access 2003 and merged into this new database for a fresh start. I went through all my DB objects and assigned permissions for them using the 'User and Group Permissions'.

I split the database to a front-end / back-end environment. I copied the FE database to a folder off the desktop for each of my DB users. I placed a shortcut for each user to get into the secure database.

Example of my shortcut:

"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" "c:\Documents and settings\%USERNAME%\Desktop\Database\My Database.mdb" /wrkgrp "\\servername\Database\My Database.mdw"

The database seemed to be running fine for a few days. Then one of my users had an issue accessing some forms and queues. So I logged onto my machine and updated those permissions. I had him try to access those objects and he still couldn't. I tested his permissions with a test login (duplicating his groups) on my PC and it worked fine.

I logged onto his PC using my admin login and checked the 'User and Group Permissions' I just had changed on my own PC. The permissions weren't set the same as my PCs version.

I verified that all the shortcuts matched properly and we where joined to the same Workgroup file. I even verified in VBA that we where using the same MDW file and we where. Using this code…

Dim strCurrMDW

strCurrMDW = SysCmd(acSysCmdGetWorkgroupFile)

I'm at a loss why it's not updated for my other DB users when we share the same MDW file. Before I start trying to re-build everything again I want to see if anyone has seen this issue before.

Regards and Thanks!
**My OS is Windows XP as is the same for the other DB users.

 

[Telecom]

When I update a database object's 'User and Group Permissions' does it matter what database location I make those from? In my situation I've been making the changes from my local PC front-end database. Will those changes follow through to the my co-workers local PC front-end database? (For linked-tables, forms, reports, etc.)

Do I have to make those 'User and Group Permission' changes on my network stored Front-End database? So my co-workers can download the latest Front-End database verison with the updated 'User and Group Permissions'?

I'm still not sure why my PC's local front-end database sees different 'User and Group Permissions' then my co-worker's local front-end database.

 

[HiTechCoach]

Do I have to make those 'User and Group Permission' changes on my network stored Front-End database? So my co-workers can download the latest Front-End database verison with the updated 'User and Group Permissions'?

YES. That is the correct way.

You must make a the changes to the "Master" front end. I normally create an new MDE/ACCDE for deployment. You will need to deploy the new updated front end to all users!

 

[Telecom]

Awesome! Thanks for helping me out with that HiTechCoach. I couldn't find that info anywhere.

 

[HiTechCoach]

You're welcome!

Glad we could assist.