Re: security settings deleted

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 02/20/05 

Date: Sun, 20 Feb 2005 03:27:44 -0800

Hi.

> When I compact and rpair the databse the security settings are deleted an
> dI
> have ot relaod them ???

There are three types of security settings available for Microsoft Access:
user-level security, shared-level security, and the Windows operating system
security. This sounds like your Windows security permissions need to be
reset after compacting and repairing the database, because the new database
file is inheriting permissions different from those the original database
file had. Both the operating system and the version of Access affect the
behavior of permission settings after database compaction. When you upgrade
the operating system or Microsoft Office, whatever behavior you are seeing
now and attempt to fix will change and will need to be readdressed.

All users of the database should have "Full Control" security permissions on
the directory where the database file is located. Do the users not have
"Full Control" after compaction?

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.)

"PRAS" <PRAS@discussions.microsoft.com> wrote in message
news:D482577F-FBA0-44D6-B9D2-A478747DA283@microsoft.com...
> When I compact and rpair the databse the security settings are deleted an
> dI
> have ot relaod them ???

Relevant Pages

  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • RE: secure areas
    ... My next problem is that I am locked out of the database ... Microsoft Access. ... Microsoft Access Security FAQ Available in ... >to visit Windows Update at ...
    (microsoft.public.access.security)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • RE: Unsecuring Tables/Forms/File and Logging on as Administrator?
    ... Here are the steps to unsecure a Microsoft Access database: ... that defines security for the database that is secured. ... Open the database you wish to unsecure using the logon that defines Admin ...
    (microsoft.public.access.security)