I had to setup security on our one of our Access Databases on our network. I
did the testing on my laptop before I setup the network database. I also
used the dataabase seurity wizard when doing this. Now when I open any
database it asks for a username and password. If I try to go back and get
into the security wizard I get an error.

"The security wizard cannot be run on a computer when you are both logged
on as the Admin user and the database has been previously secured"

I'm the only user on the database at that time. So how can I get rid of
these security settings.

Join a workgroup that does not include passwords.

Or open the database and clear your Admin password.

--
Rick B



"TickTock" <(E-Mail Removed)> wrote in message
news:272C9E1B-607B-4969-9D66-(E-Mail Removed)...
> I had to setup security on our one of our Access Databases on our network.
I
> did the testing on my laptop before I setup the network database. I also
> used the dataabase seurity wizard when doing this. Now when I open any
> database it asks for a username and password. If I try to go back and get
> into the security wizard I get an error.
>
> "The security wizard cannot be run on a computer when you are both logged
> on as the Admin user and the database has been previously secured"
>
> I'm the only user on the database at that time. So how can I get rid of
> these security settings.
>

TickTock wrote:
> I had to setup security on our one of our Access Databases on our
> network. I did the testing on my laptop before I setup the network
> database. I also used the dataabase seurity wizard when doing this.
> Now when I open any database it asks for a username and password. If
> I try to go back and get into the security wizard I get an error.

Why are you running the security wizard again?

>
> "The security wizard cannot be run on a computer when you are both
> logged on as the Admin user and the database has been previously
> secured"

Why are you logging in as 'Admin'? that user should have no permissions to
do anything. Login as a user that's a member of the Admins Group.



--
Joan Wild
Microsoft Access MVP