.MDW takes over

[EllenR]

How do I set up security for one database but not others? When I setup
payroll.mdw, the other users can't access other db's within the company.

 

[Chris Mills]

Easy.

For the secure database, specify the mdw on the command line of a shortcut
(lookup command line parameters in Access Help)

For all other usage (such as double-clicking an mdb), do not specify an mdw
and it will default to the default (system.mdw in the default folder).

DO NOT alter the mdw from the default system.mdw in the Workgroup
Administrator. You bypass that default by specifying another one (payroll.mdw)
in a specific (desktop) shortcut for that app.

Chris

 

[EllenR]

ok--how do I put the system.mdw back to its original state?

 

[Lynn Trapp]

1. log on as a member of the Admins Group
2. Add the Admin User back to the Admins Group
3. Grant full permissions to all objects on the database.
4. Get a copy of the Security FAQ (there's a link to it on the Security
page of my website), read it several times, and start over doing your
security.

 

[Chris Mills]

ok--how do I put the system.mdw back to its original state?Assuming you've modified the default system.mdw, or aren't sure

Do a Windows file search and rename all system.mdw you find (since we can't be
sure exactly where it is)

Run Access and open or create an mdb - a new default system.mdw will then be
created. I suppose you could extract it from the Office CD but the above is
easier.

Chris