Home All Groups Group Topic Archive Search About

Why can't I get to "Set Database Password"

Author
19 Oct 2006 8:20 PM
beginnergirl
I am following the instructions for setting a password on my Design Master
but when I get to the "Set Database Password" step, it is grayed out and I
cannot select it.  What gives?

Author
24 Oct 2006 8:54 PM
Joan Wild
You cannot set a database password on a replicated database.

--
Joan Wild
Microsoft Access MVP

beginnergirl wrote:
Show quoteHide quote
> I am following the instructions for setting a password on my Design
> Master but when I get to the "Set Database Password" step, it is
> grayed out and I cannot select it.  What gives?
Author
25 Oct 2006 12:26 AM
beginnergirl
Yes, I read that but I'm trying to do this with the Master Design not a
replica.

Show quoteHide quote
"Joan Wild" wrote:

> You cannot set a database password on a replicated database.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> beginnergirl wrote:
> > I am following the instructions for setting a password on my Design
> > Master but when I get to the "Set Database Password" step, it is
> > grayed out and I cannot select it.  What gives?
>
>
>
Author
25 Oct 2006 12:51 AM
Granny Spitz via AccessMonster.com
beginnergirl wrote:
> Yes, I read that but I'm trying to do this with the Master Design not a
> replica.

Hon, the design master *is* the first replica of a replicated database.  If
you want to set a database password you need to create a new database and
import the user tables and other objects from the design master into this new
database.  Open this new database in exclusive mode and set the database
password.  Use this new database not the replicated database.

--
Message posted via http://www.accessmonster.com
Author
25 Oct 2006 12:57 AM
beginnergirl
Let me make sure I understand you.  Once I have created a database, if I do
not set up the password in the initial phase, then there are no other
opportunities after that?

Show quoteHide quote
"Granny Spitz via AccessMonster.com" wrote:

> beginnergirl wrote:
> > Yes, I read that but I'm trying to do this with the Master Design not a
> > replica.
>
> Hon, the design master *is* the first replica of a replicated database.  If
> you want to set a database password you need to create a new database and
> import the user tables and other objects from the design master into this new
> database.  Open this new database in exclusive mode and set the database
> password.  Use this new database not the replicated database.
>
> --
> Message posted via http://www.accessmonster.com
>
>
Author
25 Oct 2006 1:20 AM
Granny Spitz via AccessMonster.com
beginnergirl wrote:
> Once I have created a database, if I do
> not set up the password in the initial phase, then there are no other
> opportunities after that?

If you set a database password on the database first you won't be able to
replicate it later.  If you want security you need to apply User level
security.

--
Message posted via http://www.accessmonster.com
Author
25 Oct 2006 1:42 PM
Joan Wild
There is no way to use both replication and a database password.

--
Joan Wild
Microsoft Access MVP

beginnergirl wrote:
Show quoteHide quote
> Let me make sure I understand you.  Once I have created a database,
> if I do not set up the password in the initial phase, then there are
> no other opportunities after that?
>
> "Granny Spitz via AccessMonster.com" wrote:
>
>> beginnergirl wrote:
>>> Yes, I read that but I'm trying to do this with the Master Design
>>> not a replica.
>>
>> Hon, the design master *is* the first replica of a replicated
>> database.  If you want to set a database password you need to create
>> a new database and import the user tables and other objects from the
>> design master into this new database.  Open this new database in
>> exclusive mode and set the database password.  Use this new database
>> not the replicated database.
>>
>> --
>> Message posted via http://www.accessmonster.com