Re: password problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.





--
Rick B



"R" <R@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC839970-7BBB-40D9-B1AD-F25AB6FEF090@xxxxxxxxxxxxxxxx
> 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.


.

Relevant Pages

  • Re: Activate different FE apps
    ... Database files need workgroup files, but they don't really "link" to them. ... commonly a Windows shortcut is used to open the database file while joined to ... different user groups so when one person logging onto a PC FE #1 opens then ...
    (microsoft.public.access.security)
  • Re: Activate different FE apps
    ... (it sounds from your description that you only wanted different access rights), ... Database files need workgroup files, but they don't really "link" to them. ... commonly a Windows shortcut is used to open the database file while joined to ... different user groups so when one person logging onto a PC FE #1 opens then ...
    (microsoft.public.access.security)
  • Re: password problems
    ... > I assume it is asking for a UserID and PAssword, ... > Or rejoin the SYSTEM.MDW workgroup file. ... There is more to securing a database file than ... >> different computer it opens fine and it says that that it is open under ...
    (microsoft.public.access.security)
  • RE: How to restrict users to see data in a mutiuser environment?
    ... For workgroup setup, do I need to write any code to find the user. ... interested setting up workgroup security. ... ' Gets the userid of the current user. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Setting up security level
    ... it will give you an option to 'join' a workgroup. ... but you would like to force your database to open with the ... computer and opens your database without signing on. ... There is a "Security FAQ" on the Microsoft website that talks about how to ...
    (microsoft.public.access.security)