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 19:45:53 -0700

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

  • Re: Access 2003 Macro Security Modification
    ... the desired way to prevent the macro security warning is to ... digitally sign your database. ... Your database fileon the client computer. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Database Ruined
    ... I had no idea setting up security could cause so many ... In a properly secured database, only the owner of that database has ... last time you can view these VERY important settings. ... use the exact same settings when recreating the workgroup. ...
    (microsoft.public.access.security)
  • Re: Security disapears from menubar when I add a new user
    ... > user logon and created an administrative logon called "sysadmin". ... > database owner is "sysop" and was used for development. ... by creating a new workgroup information file with a unique workgroup ... Security FAQ, ...
    (microsoft.public.access.security)
  • Re: User and Workgroup was screwed
    ... system.mdw file after he implemented the security on the database. ... we tried to create a new mdw file by using those info in the text ... password in the workgroup. ...
    (microsoft.public.access.security)
  • Re: Sorting out security
    ... There is a link to it on the Security page of my website. ... > files and remote logins to a secured database. ... different name for the secure workgroup file. ... If the Admin user has no password then every user is ...
    (microsoft.public.access.security)