.MDW takes over

2 Oct 2006 10:31 AM

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.

2 Oct 2006 10:40 AM

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

Show quoteHide quote

"EllenR" <Ell***@discussions.microsoft.com> wrote in message
news:E2411590-A65E-4B30-AFAB-3B5ECA3CB4DA@microsoft.com...
> 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.

2 Oct 2006 10:57 AM

EllenR

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

Show quoteHide quote

"Chris Mills" wrote:

> 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" <Ell***@discussions.microsoft.com> wrote in message
> news:E2411590-A65E-4B30-AFAB-3B5ECA3CB4DA@microsoft.com...
> > 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.
>
>
>

2 Oct 2006 1:19 PM

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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Show quoteHide quote

"EllenR" <Ell***@discussions.microsoft.com> wrote in message
news:FD290A0E-7E77-4E69-B308-3939C5EAFFAB@microsoft.com...
> ok--how do I put the system.mdw back to its original state?
>
> "Chris Mills" wrote:
>
>> 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" <Ell***@discussions.microsoft.com> wrote in message
>> news:E2411590-A65E-4B30-AFAB-3B5ECA3CB4DA@microsoft.com...
>> > 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.
>>
>>
>>

2 Oct 2006 7:05 PM

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