Remove DB Password-Security

[Sandy]

I have a split db and I am trying to take off the db
password on the back end. I also have a workgroup which
requires log in using a password. I am opening the back-
end using exclusive mode, but am not able to remove the
password. Does this have something to do with my
workgroup?

 

[Rick B]

Is it a database password (one prompt)? Or a userid and password? If the
former, you should be able to remove the database password. If the latter,
you will have to undo the security so that users will no longer be required
to log in.

Rick B


I have a split db and I am trying to take off the db
password on the back end. I also have a workgroup which
requires log in using a password. I am opening the back-
end using exclusive mode, but am not able to remove the
password. Does this have something to do with my
workgroup?

 

[Joan Wild]

I have a split db and I am trying to take off the db
password on the back end. I also have a workgroup which
requires log in using a password. I am opening the back-
end using exclusive mode, but am not able to remove the
password. Does this have something to do with my
workgroup?

Please don't mult-post. What happens when you try to remove the password -
do you get an error message?

 

[Sandy]

It is a split database with a database password on the
back end. Then I also have security on both front and
back end databases with a user id and password required to
enter (using the workgroup I created). The reason that I
am trying to remove the database password is that I need
to make replicas for LAN systems in other cities. I don't
want to remove my security though. Do I have to remove
the security in order to replicate?

 

[Sandy]

When I try to remove the password, I get an error message
that tells me to open the database in exclusive mode. I
am opening it in exclusive mode, but still can't remove
the password. Please see my other reply in this set of
discussions to see more details.

Thanks for any help you can give me!

 

[Joan Wild]

How are you opening in exclusive mode? If you launch the mdb via a shortcut
that specifies the workgroup, just add /excl to the end of the target.

If you aren't using a shortcut, then you must be joined to your secure
workgroup by default. Therefore, ensure you
Start Access
Use File, Open and locate your backend mdb. In the lower right of the open
dialog, click on the dropdown and choose Open Exclusive.
You'd then be prompted for the username/password and for the password on the
backend.

You should then be able to change the database password.

 

[Sandy]

I am opening the database in exclusive mode exactly as you
stated below by using the dropdown option. Then when I
try to change the password, I still get the error
message. That's why it seems so confusing to me.

 

[Joan Wild]

See if this article applies
http://support.microsoft.com/default.aspx?scid=kb;en-us;304528&Product=acc