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

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

From: joker (no-spam_at_netzero.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 01:52:58 -0600

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: database bloat/size
    ... I've also imported all objects into a new file only to watch it bloat ... until I compact it again. ... Can the security part be done in VBA? ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Prevent PDA from powering off
    ... Our application uses an SQL CE 2 database to store it's data. ... It performs a database compact and repair operation periodically ... in order to retrieve unused space and to prevent data corruption ... during a compact & repair operation - especially when the database ...
    (microsoft.public.dotnet.framework.compactframework)
  • Tested OK (How to prevent OE compaction and resulting folder corruption)
    ... How to prevent OE compaction (and resulting folder corruption) ... Windows Registry Editor Version 5.00 ... prevent that "CCC" (Compact Check Count) from approaching 100 ... security, ...
    (microsoft.public.windowsxp.general)
  • A note to add to ASPFAQ.com for database compacting
    ... I get this error after going in Access to Tools, Database Utilities, ... Compact and Repair Database... ... I checked the security tab of the file and noticed that the Compact ...
    (microsoft.public.inetserver.asp.db)
  • RE: Compacting a DB
    ... You cannot do a compact and repair operation while executing code in your ... automate it. ...
    (microsoft.public.access.modulesdaovba)