Security Snafu

8 Aug 2006 9:34 PM

Paul Hammond

I'm a security novice in Access.   I was experimenting with setting up Groups
and Users and from one PC at least I now cannot open ANY databases.   I get
asked for user name and password no matter which database I try to open.   I
can open these same databases from my alternate PC though, except for the one
I was actually trying to secure.   I have restored the usecured back up I
created, but again I can't get into any databases at all from the PC I was
working on.   I have the One step Security Wizardc Report printed and saved.
I did not set up a password for myself. I wasn't even required too.

I at least can function using my alternate PC, but I would appreciate some
assistance in rectifying this. Any suggestion will be welcomed.

Thanks,

Paul Hammond
Richmond, VA

--
Can't we all just get along?

9 Aug 2006 7:13 AM

Keith Wilby

Show quote Hide quote

"Paul Hammond" <phamm***@mediaREMOVEgeneral.com> wrote in message
news:2CC8FA55-2240-4A5B-8092-B724F77BE6F0@microsoft.com...
> I'm a security novice in Access.   I was experimenting with setting up
> Groups
> and Users and from one PC at least I now cannot open ANY databases.   I
> get
> asked for user name and password no matter which database I try to open.
> I
> can open these same databases from my alternate PC though, except for the
> one
> I was actually trying to secure.   I have restored the usecured back up I
> created, but again I can't get into any databases at all from the PC I was
> working on.   I have the One step Security Wizardc Report printed and
> saved.
> I did not set up a password for myself. I wasn't even required too.
>
> I at least can function using my alternate PC, but I would appreciate some
> assistance in rectifying this. Any suggestion will be welcomed.
>

This is a common occurrence. You have either modified the default
"system.mdw" workgroup file or you have joined, by default, the custom
workgroup file you created in securing your app.

If the former, then re-name "system.mdw" and Access (2k on) will create a
new "clean" one on startup. If the latter, then re-join "system.mdw" using
the workgroup admin tool.

HTH - Keith.
www.keithwilby.com

9 Aug 2006 1:01 PM

Paul Hammond

Yes it did help and I thank you.

Now I will try again and see if I can avoid repeating this mistake. It
seems a high price to pay for something so easy to do. Any tips on how to
avoid?

Paul

--

Show quoteHide quote

"Keith Wilby" wrote:

> "Paul Hammond" <phamm***@mediaREMOVEgeneral.com> wrote in message
> news:2CC8FA55-2240-4A5B-8092-B724F77BE6F0@microsoft.com...
> > I'm a security novice in Access.   I was experimenting with setting up
> > Groups
> > and Users and from one PC at least I now cannot open ANY databases.   I
> > get
> > asked for user name and password no matter which database I try to open.
> > I
> > can open these same databases from my alternate PC though, except for the
> > one
> > I was actually trying to secure.   I have restored the usecured back up I
> > created, but again I can't get into any databases at all from the PC I was
> > working on.   I have the One step Security Wizardc Report printed and
> > saved.
> > I did not set up a password for myself. I wasn't even required too.
> >
> > I at least can function using my alternate PC, but I would appreciate some
> > assistance in rectifying this. Any suggestion will be welcomed.
> >
>
> This is a common occurrence. You have either modified the default
> "system.mdw" workgroup file or you have joined, by default, the custom
> workgroup file you created in securing your app.
>
> If the former, then re-name "system.mdw" and Access (2k on) will create a
> new "clean" one on startup. If the latter, then re-join "system.mdw" using
> the workgroup admin tool.
>
> HTH - Keith.
> www.keithwilby.com
>
>
>

9 Aug 2006 2:32 PM

Keith Wilby

"Paul Hammond" <phamm***@mediaREMOVEgeneral.com> wrote in message
news:7FB70091-F52E-4491-B27F-EF3360372F59@microsoft.com...
> Yes it did help and I thank you.

No problem, glad to help.

>
> Now I will try again and see if I can avoid repeating this mistake. It
> seems a high price to pay for something so easy to do. Any tips on how to
> avoid?

IMO the most valuable piece of advice you'll receive on here is to make
backups of your files before you make any changes to your security, it's so
very easy to mess up, even when you're experienced!

Regards,
Keith.