"Nanette" <Nane***@discussions.microsoft.com> wrote in message
news:79BBCB26-590E-4FF4-B332-D0E0CCDAC94F@microsoft.com...
>I added security to a database that I've been moving back and forth between
> work and home. I copy the database onto a thumb drive and bring it home
> and
> visa versa.
>
> This holiday I experimented with adding security. Everything worked fine,
> but now I'm concerned about copying the newest database and bringing it to
> work.
>
> I'd like any comments about this and if I should attempt to completely
> delete the security before I copy it and take it back to work.

"Douglas J. Steele" wrote:

> As long as you've got the MDW that you used to add security, you should be
> okay.
>
> If you don't want to use that MDW file at work, then yes, you probably
> should remove security on the copy before taking it back to work.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Nanette" <Nane***@discussions.microsoft.com> wrote in message
> news:79BBCB26-590E-4FF4-B332-D0E0CCDAC94F@microsoft.com...
> >I added security to a database that I've been moving back and forth between
> > work and home. I copy the database onto a thumb drive and bring it home
> > and
> > visa versa.
> >
> > This holiday I experimented with adding security. Everything worked fine,
> > but now I'm concerned about copying the newest database and bringing it to
> > work.
> >
> > I'd like any comments about this and if I should attempt to completely
> > delete the security before I copy it and take it back to work.
>
>
>

"Rick Brandt" wrote:

> "Nanette" <Nane***@discussions.microsoft.com> wrote in message
> news:FE42C49F-2DB4-40C7-84D5-CD4C8ED93E4A@microsoft.com...
> > Would deleting the MDW file get rid of all the security?
>
> No.  If you applied security properly deleting the MDW file would make your file
> useless as you should not be able to open it unless you are logged into that MDW
> file.
>
> If you CAN open it with another MDW then you never secured it properly in the
> first place.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
>
>
>

"Rick Brandt" wrote:

> "Nanette" <Nane***@discussions.microsoft.com> wrote in message
> news:8326C01C-A787-4599-BCAB-2F81995915AB@microsoft.com...
> > What is the safest way to get rid of all security on a database?
>
> Open the file with a profile that has administrator rights and grant full rights
> on all objects to the Users group.
>
> Close Access and reopen using the default System.MDW file.
>
> Create a new blank file and import into it all objects from your current file.
>
> The resulting file will be identical to one that never had security applied.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
>
>
>