Could someone help me please? After upgrading to Access
2000, I'm now prompted for a password where I wasn't
prompted before. One of the SAs upgraded my box and
nobody knows how to fix the problem. I'm so lost and
don't know what to do.

Thanks in advance.
Lee

Is it asking when you start Access or when you try to open a database?
If the second, have you tried a different database?

Have you implemented Access security or has a password been set for the
database (to very different things)?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


"L. Drofdem" <(E-Mail Removed)> wrote in message
news:0c6f01c36b46$a5be22d0$(E-Mail Removed)...
> Could someone help me please? After upgrading to Access
> 2000, I'm now prompted for a password where I wasn't
> prompted before. One of the SAs upgraded my box and
> nobody knows how to fix the problem. I'm so lost and
> don't know what to do.
>
> Thanks in advance.
> Lee

I can't open any databases. The application starts up but
the databases won't load without a password. My password
does not work.


>-----Original Message-----
> Is it asking when you start Access or when you try to
open a database?
>If the second, have you tried a different database?
>
> Have you implemented Access security or has a
password been set for the
>database (to very different things)?
>
>--
>Joseph E. Meehan
>
>26 + 6 = 1 It's Irish Math
>
>
>"L. Drofdem" <(E-Mail Removed)> wrote in message
>news:0c6f01c36b46$a5be22d0$(E-Mail Removed)...
>> Could someone help me please? After upgrading to Access
>> 2000, I'm now prompted for a password where I wasn't
>> prompted before. One of the SAs upgraded my box and
>> nobody knows how to fix the problem. I'm so lost and
>> don't know what to do.
>>
>> Thanks in advance.
>> Lee
>
>
>.
>

Yes. It is so sad. My other box works fine so I know I
can open those databases without a password. But I can't
do anything on my upgraded system. It even asks for a
password if I try to create a blank database.


>-----Original Message-----
> So Access opens and then using the "File Open" menu
or "recently used"
>list selection in Access it asks for a password when you
try to open an
>application?
>
>
>--
>Joseph E. Meehan
>
>26 + 6 = 1 It's Irish Math
>
>
>"L. Drofdem" <(E-Mail Removed)> wrote in message
>news:044401c36b4b$ff806670$(E-Mail Removed)...
>> I can't open any databases. The application starts up
but
>> the databases won't load without a password. My
password
>> does not work.
>>
>>
>> >-----Original Message-----
>> > Is it asking when you start Access or when you try
to
>> open a database?
>> >If the second, have you tried a different database?
>> >
>> > Have you implemented Access security or has a
>> password been set for the
>> >database (to very different things)?
>> >
>> >--
>> >Joseph E. Meehan
>> >
>> >26 + 6 = 1 It's Irish Math
>> >
>> >
>> >"L. Drofdem" <(E-Mail Removed)> wrote in message
>> >news:0c6f01c36b46$a5be22d0$(E-Mail Removed)...
>> >> Could someone help me please? After upgrading to
Access
>> >> 2000, I'm now prompted for a password where I wasn't
>> >> prompted before. One of the SAs upgraded my box and
>> >> nobody knows how to fix the problem. I'm so lost and
>> >> don't know what to do.
>> >>
>> >> Thanks in advance.
>> >> Lee
>> >
>> >
>> >.
>> >
>
>
>.
>

Are you prompted for a username and password, or just a password? (It
sounds like the former).

--
Joan Wild
Microsoft Access MVP

"l. drofdem" <(E-Mail Removed)> wrote in message
news:059201c36bd7$175bd1e0$(E-Mail Removed)...
> Yes. It is so sad. My other box works fine so I know I
> can open those databases without a password. But I can't
> do anything on my upgraded system. It even asks for a
> password if I try to create a blank database.

I'm prompted for both. My network logon ID and password
don't work. I've tried every password I know and I can't
do anything.


>-----Original Message-----
>Are you prompted for a username and password, or just a
password? (It
>sounds like the former).
>
>--
>Joan Wild
>Microsoft Access MVP
>
>"l. drofdem" <(E-Mail Removed)> wrote in message
>news:059201c36bd7$175bd1e0$(E-Mail Removed)...
>> Yes. It is so sad. My other box works fine so I know I
>> can open those databases without a password. But I
can't
>> do anything on my upgraded system. It even asks for a
>> password if I try to create a blank database.
>
>
>.
>

"l.drofdem" <(E-Mail Removed)> wrote in message
news:011f01c36be4$ca7ab220$(E-Mail Removed)...
> I'm prompted for both. My network logon ID and password
> don't work. I've tried every password I know and I can't
> do anything.
>

Well that's what Joseph was trying to get at. There are two possible
password prompts in Access - a database password has been set; or user-level
security is in play.

It sounds to me as though you have not secured any databases, but you are
joined by default to a workgroup file that has a password set for the Admin
user (which causes the login to appear).

Using Start, Search, find all the *.mdw files on your computer. Hopefully
there's more than one - if only one then post back.

Next use Start, Run, wrkgadm.exe. This will show you the mdw file your
computer is joined to by default - meaning every time you open a database,
it will use this workgroup file.

Click on Join and rejoin the standard system.mdw that ships with Access (it
usually is located in the windows system folder). This mdw, as long as no
one played with it, should have no password set for the Admin user (and thus
you won't get a login prompt).

--
Joan Wild
Microsoft Access MVP

I only have the one file and it is called green_system.mdw
that is a shortcut to a file on the network. My coworker
has the same shortcut on his system and all of his stuff
still works.


>-----Original Message-----
>"l.drofdem" <(E-Mail Removed)> wrote in message
>news:011f01c36be4$ca7ab220$(E-Mail Removed)...
>> I'm prompted for both. My network logon ID and password
>> don't work. I've tried every password I know and I
can't
>> do anything.
>>
>
>Well that's what Joseph was trying to get at. There are
two possible
>password prompts in Access - a database password has been
set; or user-level
>security is in play.
>
>It sounds to me as though you have not secured any
databases, but you are
>joined by default to a workgroup file that has a password
set for the Admin
>user (which causes the login to appear).
>
>Using Start, Search, find all the *.mdw files on your
computer. Hopefully
>there's more than one - if only one then post back.
>
>Next use Start, Run, wrkgadm.exe. This will show you the
mdw file your
>computer is joined to by default - meaning every time you
open a database,
>it will use this workgroup file.
>
>Click on Join and rejoin the standard system.mdw that
ships with Access (it
>usually is located in the windows system folder). This
mdw, as long as no
>one played with it, should have no password set for the
Admin user (and thus
>you won't get a login prompt).
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>.
>

So that I'm clear. You have Access 2000 installed on your computer.

Is your database secure? i.e. does your coworker open the database by
entering a username/password?

You do not have any mdw files on your computer. You have a shortcut that
points to a mdw file on the network.

What is in the target of this shortcut?


--
Joan Wild
Microsoft Access MVP


"L. drofdem" <(E-Mail Removed)> wrote in message
news:09f301c36bfd$bd9b8610$(E-Mail Removed)...
> I only have the one file and it is called green_system.mdw
> that is a shortcut to a file on the network. My coworker
> has the same shortcut on his system and all of his stuff
> still works.
>

My database is not secure. I created it when I had Access
97. My coworker can access it without a username or
password. The only file in that network directory is the
green_system.mdw file. My coworker also has the same
shortcut on his system and does not have any other mdw
file on his system. My system is an upgrade to Access
2000 but his is a new system. I could access all my
databases before I was upgraded without entering a
username/password.


>-----Original Message-----
>So that I'm clear. You have Access 2000 installed on
your computer.
>
>Is your database secure? i.e. does your coworker open
the database by
>entering a username/password?
>
>You do not have any mdw files on your computer. You have
a shortcut that
>points to a mdw file on the network.
>
>What is in the target of this shortcut?
>
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>"L. drofdem" <(E-Mail Removed)> wrote in message
>news:09f301c36bfd$bd9b8610$(E-Mail Removed)...
>> I only have the one file and it is called
green_system.mdw
>> that is a shortcut to a file on the network. My
coworker
>> has the same shortcut on his system and all of his stuff
>> still works.
>>
>
>
>.
>