469,353 Members | 2,101 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,353 developers. It's quick & easy.

MS Access asking for password

Mo
A user is complaining that Access Dbs on her PC asks her to type in a
username and password whenever she opens an Access Db. The username that
appears in the username box is the same as her network username.

No password actually works to open any DB. I've also logged in to that pc
using the Admin account and get the same problem. She does not not have this
problem (i.e. opening the same Db) on another pc.

The Db in question is NOT secured and has not had a password applied to it.

Anyone have any ideas what's happening here?

TIA
Nov 13 '05 #1
10 16231
"Mo" <m.********@nospam.qmul.ac.uk> wrote:
The Db in question is NOT secured and has not had a password applied to
it.

Anyone have any ideas what's happening here?


Yes, someone has either:

1 - used the Workgroup Admin utility to change the default Workgroup
Information File (WIF) to something other than "System.mdw" or

2 - modified "System.mdw" from another Access app.

You need to find out which:

Open the Workgroup Admin utility to see if the default workgroup is (for
NT) C:\WINNT\System32\System.mdw.

If it isn't, browse to this file and select it.

If it is then you need a 'clean' copy of System.mdw. You may well be able
to just copy a clean one from another PC, but I'd advise to make sure it's
one from an identical MS Office image.

HTH - Keith.
www.keithwilby.org.uk
Nov 13 '05 #2
Mo
Thanks very much for the suggestion Keith

The System.mdw was there. I replaced it with a clean copy as you suggested
and I still have access prompting me for a password.

Any other ideas.

Mo
Yes, someone has either:

1 - used the Workgroup Admin utility to change the default Workgroup
Information File (WIF) to something other than "System.mdw" or

2 - modified "System.mdw" from another Access app.

You need to find out which:

Open the Workgroup Admin utility to see if the default workgroup is (for
NT) C:\WINNT\System32\System.mdw.

If it isn't, browse to this file and select it.

If it is then you need a 'clean' copy of System.mdw. You may well be able
to just copy a clean one from another PC, but I'd advise to make sure it's
one from an identical MS Office image.

HTH - Keith.
www.keithwilby.org.uk

Nov 13 '05 #3
"Mo" <m.********@nospam.qmul.ac.uk> wrote in message
news:ce**********@beta.qmul.ac.uk...
Thanks very much for the suggestion Keith

The System.mdw was there. I replaced it with a clean copy as you suggested and I still have access prompting me for a password.

Any other ideas.


Are you asked for a user name and password or just a password? User-Level
security would ask for both. If you are only asked for a password then
either someone HAS applied a password or your file is corrupted.
Unfortunately that form of corruption is usually not correctable (except by
reverting to a backup).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4
Mo
Rick,

I'm asked for both the username and password - but on all Access Dbs I try
to open from that pc.

Any ideas where to go next?

TIA

Mo


Are you asked for a user name and password or just a password? User-Level
security would ask for both. If you are only asked for a password then
either someone HAS applied a password or your file is corrupted.
Unfortunately that form of corruption is usually not correctable (except by reverting to a backup).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #5
"Mo" <m.********@nospam.qmul.ac.uk> wrote in message
news:ce**********@beta.qmul.ac.uk...
Rick,

I'm asked for both the username and password - but on all Access Dbs I try to open from that pc.

Any ideas where to go next?


That indicates that you are using a default workgroup file that has a
password on the "Admin" user. Just copy the System.mdw file from another
PC and "join" it. That should solve the problem. If you already replaced
System.mdw and it didn't help then that user does not have System MDW set
as their default. Use the Workgroup Administrator to change that.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #6
Mo, what's in the shortcut? Does it have /wrkgrp in it? If it does just remove it.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" c:\vms\vms.mdb /wrkgrp c:\vms\vms.mdw /excl

"Mo" <m.********@nospam.qmul.ac.uk> wrote in message news:ce**********@beta.qmul.ac.uk...
Rick,

I'm asked for both the username and password - but on all Access Dbs I try
to open from that pc.

Any ideas where to go next?

TIA

Mo


Are you asked for a user name and password or just a password? User-Level
security would ask for both. If you are only asked for a password then
either someone HAS applied a password or your file is corrupted.
Unfortunately that form of corruption is usually not correctable (except by reverting to a backup).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #7
Mo,
It sounds as though the workgroup file you need is in place, you just
need to join the correct workgroup.

From Access Help:

1.. Start Microsoft Access.
2.. On the Tools menu, point to Security, and then click Workgroup
Administrator.
3.. In the Workgroup Administrator dialog box, click Join.
4.. Type the path and name of the workgroup information file that defines
the Microsoft Access workgroup you want to join, and then click OK, or click
Browse and then use the Select Workgroup Information File dialog box to
locate the workgroup information file.

"Mo" <m.********@nospam.qmul.ac.uk> wrote in message
news:ce**********@beta.qmul.ac.uk...
Rick,

I'm asked for both the username and password - but on all Access Dbs I try
to open from that pc.

Any ideas where to go next?

TIA

Mo


Are you asked for a user name and password or just a password? User-Level security would ask for both. If you are only asked for a password then
either someone HAS applied a password or your file is corrupted.
Unfortunately that form of corruption is usually not correctable (except

by
reverting to a backup).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #8
Mo
Thanks to all of you responded to my cries for help! Prpblem duly resolved!

Mo
Nov 13 '05 #9
Mo
Thanks to all who responded.....

Maybe I'm being a bit thick here guys, I've just tried what one or two of
you suggested, 'joining' a different workgroup. I get asked to supply a
username and password. Since anything I supply is invariably wrong, I'm
unable to get to the stage where I can specify a different workgroup to
'join'.

Am I missing something?

Mo
Nov 13 '05 #10

Mo wrote:
Thanks to all who responded.....

Maybe I'm being a bit thick here guys, I've just tried what one or two of you suggested, 'joining' a different workgroup. I get asked to supply a username and password. Since anything I supply is invariably wrong, I'm unable to get to the stage where I can specify a different workgroup to 'join'.

Am I missing something?

Mo


MO,
I had the same problem and I uninstalled and reinstalled office and
that solved the problem.

jwogdn

Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Rudi Groenewald | last post: by
5 posts views Thread by Dave Kolb | last post: by
70 posts views Thread by lgbjr | last post: by
10 posts views Thread by Daniel | last post: by
6 posts views Thread by cyndithomas via AccessMonster.com | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.