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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Nicolae Fieraru" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>