Re: Access Always Asks for Authentication

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 09/23/04 

Date: Wed, 22 Sep 2004 22:28:05 -0700

Hi, Andrew.

> However, when I try and run the System.mdw, it still prompts for a
username
> and password. Is there a default?

That's the default workgroup information file, not the Workgroup
Administrator. (Although it _is_ an Access database file, just a special
type of database file.)

Use the Access Workgroup Administrator (WRKGADM.EXE) to join this default
workgroup. The default directory for the Workgroup Administrator file is:

C:\Program Files\Microsoft Office\Office\1033

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Andrew Hatfield" <AndrewHatfield@discussions.microsoft.com> wrote in
message news:43B0EF5E-5219-4839-B330-4D5EC67BF808@microsoft.com...
> Hi,
>
> Thanks for the reply. Been such a long time since I've used Access, I'd
> forgotten about that.
>
> However, when I try and run the System.mdw, it still prompts for a
username
> and password. Is there a default?
>
> "'69 Camaro" wrote:
>
> > Hi, Andrew.
> >
> > Neither of those KB articles will help your client, because the client
is
> > using user-level security (this requires a User ID and user password),
not
> > shared-level security (this requires only a database password).
> >
> > To prevent having to provide a user name and password every time
Microsoft
> > Access attempts to open a database or create a new one, the client will
need
> > to do one of the following:
> >
> > 1.) Use the Workgroup Administrator to join the default workgroup (the
> > default location for this file depends upon the operating system, but
you
> > may find it in: C:\Program Files\Common Files\System\System.MDW), or
> >
> > 2.) Join some other workgroup that does not have a password assigned to
the
> > Admin user, or
> >
> > 3.) Remove the password from the Admin user for his current workgroup.
> >
> > To find out more about Access security, you can read the Security FAQ on
> > this Web page:
> >
> >
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
> >
> > HTH.
> >
> > Gunny
> >
> > See http://www.QBuilt.com for all your database needs.
> > See http://www.Access.QBuilt.com for Microsoft Access tips.
> >
> > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> > will be forwarded to me.)
> >
> >
> > "Andrew Hatfield" <AndrewHatfield@discussions.microsoft.com> wrote in
> > message news:B9A4CB4F-4BA4-4A1F-9EFE-171C8AF0A57C@microsoft.com...
> > > BTW : This occurs as either a non privilaged AD user or administrator
> > >
> > > "Andrew Hatfield" wrote:
> > >
> > > > I have a client that has been using Microsoft Access 2000.
> > > >
> > > > Now when they open a database or try and create a new one, it
prompts
> > for a
> > > > username and password.
> > > >
> > > > I have read KB #321905 and #243895 and while #321905 may be the
cause,
> > it
> > > > doesn't give me a resolution.
> > > >
> > > > If I try and goto to Tools | Security | User and Group Accounts it
> > prompts
> > > > me for the same settings.
> > > >
> > > > This is running on a Windows 2000 Server in TS application mode.
(2000
> > > > Build 2195 Service Pack 4
> > > >
> > > > Access version is 2000 (9.0.3821 SR-1)
> > > >
> > > >
> >
> >
> >

Relevant Pages

  • How do I bind username password security to a specific database fi
    ... After creating a workgroup information file and adding username ... password security for one database file, that security was enforced for any ... access database file that I opened on my pc. ...
    (microsoft.public.access.security)
  • Re: Recovering Access 2002 data file w/out Workgroup Adminstrator file
    ... Did you delete the mdw file or are you saying you can't find the Workgroup ... the workgroup administrator is ... built-in to the 2002 Tools menu. ... > I have an Access 2002 database file and the Workgroup ...
    (microsoft.public.access.security)
  • Re: [Full-Disclosure] Re: Full-Disclosure digest, Vol 1 #933 - 11 msgs
    ... product cart database file is located at ... >> administrator with HTTP request logs. ... >> of HTTP requests and present them to the administrator as is, thus, allowing ... >> attacker to embed malicious HTML tags that will later be parsed and executed ...
    (Full-Disclosure)
  • [Full-Disclosure] Re: Full-Disclosure digest, Vol 1 #933 - 11 msgs
    ... product cart database file is located at ... > be parsed by the web site administrator's browser, ... > administrator with HTTP request logs. ... > of HTTP requests and present them to the administrator as is, thus, allowing ...
    (Full-Disclosure)
  • Re: Domain and Workgroup problem
    ... If the workstation is joined to the domain; and you are logging onto the ... Access this computer from the network right. ... The person who administered it added a workgroup. ... > logons--both as administrator (not as AN administrator but as THE ...
    (microsoft.public.win2000.networking)