When compacting Access 2000 database, I lose "Everyone" from security group...

  • Thread starter Thread starter Nicolae Fieraru
  • Start date Start date
N

Nicolae Fieraru

Hi All,

I have an access database, located in "C:\Inetpub\wwwroot\My Webs\db"

Everytime I open the database in Access and run the Compact and Repair
database, I lose the "Everyone" group from the security tab in properties
(Windows XP OS) and I have to add the group manually. Is there a work around
to prevent this action from happening? I notmally set Everyone with full
control, because I am using the database locally for testing with asp pages.

Regards,
Nicolae
 
I'm assuming that the permissions for the actual MDB file are different than
they are for the folder. If so, what's happening is normal: compacting
creates a new file (which inherits its permissions from the folder), deletes
the old file, then renames the new file.

See whether the code MichKa has at
http://www.trigeminal.com/codes.asp?ItemID=25#25 to copy the NT file
permissions from one file to another helps.
 
Back
Top