password problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that is on a shared drive. Everyone can get to it and open
it, but if you try to open it on one computer it asks for a password. The
problem is that it doesn't like any of the passwords. If we open it on a
different computer it opens fine and it says that that it is open under
admin....it also looks like there are no passwords associated with it. Does
this mean that it is just the one computer...the person was trying to set up
different accounts, now that this has happened though I don't know how to get
rid of the problem on the computer even though I can open it on mine. Does
anyone have any ideas.....we use Access 2000.
 
I assume it is asking for a UserID and PAssword, not just a password? These
are very different situations.

If so, then the workgroup to which that one computer is joined has a
password associated with the ADMIN user. Sign on as ADMIN And clear the
password.

Or rejoin the SYSTEM.MDW workgroup file.

If they are already in the SYSTEM.MDW file and they screwed it up (very bad
idea to use that workgroup file) then delete that mdw file and Access will
create a new one when it starts up.

If anyone wants to 'messa round' with userids and passwords, they should do
so in a new workgroup file. They should also READ and REREAD the Security
FAQ. Even if they had figured it out, anyone could have take their "secure"
database file to another computer and opened it with no userid and password
and had full access to it. There is more to securing a database file than
just adding userids and passwords.
 
Thanks for responding.

They were playing around with user/admin groups and passwords. Initially
when they told me they open anything in Access at all. I deleted the
system.mdw file and reinstalled to try and correct it. This helped a bit and
has allowed them to get into Access again...BUT there is still ONE FILE that
pops up asking for a password (the input box asks for a password only, no
name or user id)
 
If it is ONLY asking for a password, then they set a database password.

The only way to fix that is to enter the password. You can then remove it
in the Tools/Security menu item.
 
All the passwords that she tried aren't working. But if we can open it on
different computers shouldn't there be a way around it on her computer????
 
That's usually a sign that the user opened it in something other than
Access; perhaps Word?

Anyway, copy the frontend from someone else's computer.

Also double-check the workgroup that she is joined to by default.
 
There's no way that the exact same database file would ask for a
database password on one PC, but not on other PCs, imho.

If it /does/ ask for a database password on one PC, but not on other
PCs, you must be using different files, or you have changed the file,
somehow, on one or more of those PCs.

HTH,
TC
 
Sounds good...I would like to try that....one more little question....what is
the frontend...I assume I could just copy like a reagular file????

Sorry for the stupid question but I'm only a practicum student trying to
help out someone in my office and I don't know a whole lot about Access.
There is no IT department or DB Admin so there insn't really anyone to help
her.
Thanks
 
R said:
Sounds good...I would like to try that....one more little question....what
is
the frontend...I assume I could just copy like a reagular file????
Click to expand...

You said you can open this file on other computers, correct? But on her's
it asks for a password (not a username and password). I assumed that the
database was split i.e. the backend (a mdb with just the
tables/relationships) is on the server, and everyone has a copy of the
frontend (a mdb with all the other objects) on their PC. The 'frontend' mdb
contains links to the backend on the server.

Since her copy of the frontend is the only one asking for a password, it
could be corrupt. You should be able to copy a working frontend from
another computer. (Yes, just a regular file copy).

If it isn't set up like this, please be more specific.
 
Back
Top