Re: A note to add to ASPFAQ.com for database compacting

From: Mike (mike_newsgroups_at_yahoo.com)
Date: 08/13/04 

Date: 13 Aug 2004 09:28:04 -0700

I set the database directory permission to give full access to
everyone, then checked "Allow inheritable permissions from parent to
propagate to this object" on the database file. However, the "compact
and repair" operation clears the check, making the file permissions
default back to the windows default (I'm using Access 2000 on win
2000) and not the permissions of the directory the file is in. So
what am I doing wrong? Is it because I gave full access to everyone
on that folder? Can I set an "internet directory default" in windows
control panel somewhere?

Thanks,
Mike

joker <no-spam@netzero.com> wrote in message news:<u7SdFh3fEHA.2812@tk2msftngp13.phx.gbl>...
> This is because when access does the compact & repair operations it has
> to create a new temporary file. Then the new file inherits the NTFS
> permissions of the folder in question depending on the rules of NTFS
> security. Thus your problem is that you have to high of security set
> for your access folder.
>
> One thing you might consider is creating a directory just for you access
> file(s) and setting the folders security so that you can still access
> them from the Internet.
>
> This will help you out because it will only give the Internet access to
> the files needed and also a compact & repair operation will not cause
> you any problems.
>
> The only change I suggest is to make note of NTFS security inheritance
> and how it effects an access database that has had a compact & repair
> operation performed on it.
>
> Mike wrote:
>
> > I'd like to add my 2 cents from the school of hard knocks to
> > http://www.aspfaq.com/show.asp?id=2009
> >
> > I get this error after going in Access to Tools, Database Utilities,
> > Compact and Repair Database...
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> > registry key 'Temporary (volatile) Jet DSN for process 0x2a4 Thread
> > 0x5cc DBC 0x15d18bc Jet'.
> > /copydata.asp, line 135
> >
> > I checked the security tab of the file and noticed that the Compact
> > and Repair operation had reset the securities settings, causing the
> > error. Each time I compact and repair the database, the security
> > settings get reset and I have to go back and manually edit them to fix
> > the problem.
> >
> > -Mike

Relevant Pages

  • Re: Creating security for MS Access application
    ... I wanted to create user ids and grant permissions based on user ids. ... You've not properly secured your database if that's the case. ... of User Level Security before mucking around with it too much more. ... with instructions on how to properly secure a database without the Security Wizard: ...
    (microsoft.public.access.security)
  • Sorting out security
    ... MS Access security. ... created a new workgroup, added a password for the Admin role, added groups, ... user IDs and passwords for users and allocated permissions on the ... remote logins to a secured database. ...
    (microsoft.public.access.security)
  • RE: Security setup does not allow import of tables
    ... When you click on the menu option Tools> Security> User and Group ... Permissions at the bottom of the screen does it show you logged in as the ... | new system database that has a unique Name, Organization, ... In the User and Group Accounts dialog box, ...
    (microsoft.public.access.security)
  • Re: Access db accessibility (permissions??)
    ... if you have not then your computers are workgrouped, security becomes a bit ... password when you first login to your database. ... > folder and then delete it. ... So the permissions are RWED on that folder. ...
    (microsoft.public.access.security)
  • 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)