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

  • Thread starter Nicolae Fieraru
  • 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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open Access from a Group account. 2
After compacting the database loses file permissions 0
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Shared group lost after compacting database 9
I'm not able to open my secured database 4
User has group permissions to object, but still denied access. 3
Problems setting up access security 12
Clarity needed re: compacting a database 11

Top