mdw security file question

[PaulA]

I have a shared database (mdb file accessed through Access 2007). Users access the file through a shortcut which includes an mdw file for user security. Each user has a front end application on their hard drive, and the mdw file with the backend database is on a shared server.

If an administrator changes the security settings from one front end file, shouldn't the changes occur for all other users, since the mdw file is shared?

For some strange reason, changes in the mdw file don't seem to be being applied to all users. I have checked the shortcut mapping and the mdw file is definitely in a shared location and the same shortcut is used by all users.

Any explanations?

Thanks.

Paul

 

[DavidAtWork]

How does the shortcut on each users machine read. Does it include the switch for the workgroup mdw file, I'm not sure if the mdw file can be set as a shared file, but you could try something like
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\FrontEndFolder\FE.mdb" /wrkgrp "S:\MDWfolder\USERS.mdw

where S: is the shared drive and USERS.mdw is the name of the mdw file
TBH, I've never used a mdw file myself before

David

 

[PaulA]

Thanks for your response, David--

I found out that the mdw file considers the users and groups configuration but object permissions are house on mdb file. That means I have to make the change on one mdb file and replace every user's mdb file with that one.

 

[prley]

Thanks for your response, David--

I found out that the mdw file considers the users and groups configuration but object permissions are house on mdb file. That means I have to make the change on one mdb file and replace every user's mdb file with that one.

Quite true. Sometimes it rears it's ugly head when you have multiple users/databases. You might want to stat considering using a versioning/auto update utilitiy. Bob Larson has made a great tool. It's a little difficult to get going but once you have it running properly it's a beautiful thing. You can check out his tool here:

http://www.access-programmers.co.uk/forums/showthread.php?t=111132

The link to his code is in his signature.

I don't know how I get along without it now.