Home All Groups Group Topic Archive Search About

help, I enabled the security wizard

Author
12 Dec 2006 7:45 PM
MissieD
I tried to put low security on my macros and instead I selected the security
Wizard and locked myself out of our database.  It was created by a previous
employee on a computer we no longer have.  When I open up the database, I get
a message saying I do not have permission, see the administrator or person
who created the dB.  What can I do?

Author
12 Dec 2006 8:10 PM
Joan Wild
Since you are using 2003, the wizard likely created a backup of your
database in its unsecure state.

Look in the folder where your mdb is located for a file with the same name,
but a bak extension.

Rename this file to have a mdb extension, and open it.


--
Joan Wild
Microsoft Access MVP

MissieD wrote:
Show quoteHide quote
> I tried to put low security on my macros and instead I selected the
> security Wizard and locked myself out of our database.  It was
> created by a previous employee on a computer we no longer have.  When
> I open up the database, I get a message saying I do not have
> permission, see the administrator or person who created the dB.  What
> can I do?
Author
12 Dec 2006 8:51 PM
MissieD
Thank you, thank you, thank you.  That worked just like you said.



Show quoteHide quote
"Joan Wild" wrote:

> Since you are using 2003, the wizard likely created a backup of your
> database in its unsecure state.
>
> Look in the folder where your mdb is located for a file with the same name,
> but a bak extension.
>
> Rename this file to have a mdb extension, and open it.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> MissieD wrote:
> > I tried to put low security on my macros and instead I selected the
> > security Wizard and locked myself out of our database.  It was
> > created by a previous employee on a computer we no longer have.  When
> > I open up the database, I get a message saying I do not have
> > permission, see the administrator or person who created the dB.  What
> > can I do?
>
>
>
Author
12 Dec 2006 9:44 PM
Joan Wild
Good!  Now you can safely delete your 'secure' mdb file and any mdw files
the wizard created.  You might also find a shortcut on the desktop that it
created - delete that too.

--
Joan Wild
Microsoft Access MVP

MissieD wrote:
Show quoteHide quote
> Thank you, thank you, thank you.  That worked just like you said.
>
>
>
> "Joan Wild" wrote:
>
>> Since you are using 2003, the wizard likely created a backup of your
>> database in its unsecure state.
>>
>> Look in the folder where your mdb is located for a file with the
>> same name, but a bak extension.
>>
>> Rename this file to have a mdb extension, and open it.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> MissieD wrote:
>>> I tried to put low security on my macros and instead I selected the
>>> security Wizard and locked myself out of our database.  It was
>>> created by a previous employee on a computer we no longer have.
>>> When I open up the database, I get a message saying I do not have
>>> permission, see the administrator or person who created the dB.
>>> What can I do?