Remove DB Password-Security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 17 May 2004 15:15 GMT

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?

Reply to this Message

Rick B - 17 May 2004 15:38 GMT

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?

Reply to this Message

Sandy - 17 May 2004 18:34 GMT

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?

>-----Original Message-----
>Is it a database password (one prompt)? Or a userid and password? If the
[quoted text clipped - 12 lines]
>
>.

Reply to this Message

Joan Wild - 17 May 2004 15:45 GMT

> 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?

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Sandy - 17 May 2004 18:36 GMT

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!

>-----Original Message-----
>> I have a split db and I am trying to take off the db
[quoted text clipped - 6 lines]
>Please don't mult-post. What happens when you try to remove the password -
>do you get an error message?

Reply to this Message

Joan Wild - 17 May 2004 18:55 GMT

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.

Signature

Joan Wild
Microsoft Access MVP

> When I try to remove the password, I get an error message
> that tells me to open the database in exclusive mode. I
[quoted text clipped - 3 lines]
>
> Thanks for any help you can give me!

Reply to this Message

Sandy - 17 May 2004 19:19 GMT

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.

>-----Original Message-----
>How are you opening in exclusive mode? If you launch the mdb via a shortcut
[quoted text clipped - 19 lines]
>
>.

Reply to this Message

Joan Wild - 17 May 2004 20:36 GMT

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

> I am opening the database in exclusive mode exactly as you
> stated below by using the dropdown option. Then when I
[quoted text clipped - 29 lines]
>>
>> .

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message