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.
 

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
Access 2007 Command Line /compact encrypted .accdb 2
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Removing Admin Permissions from my database 1
After compacting the database loses file permissions 0
Security Problem When Linking Tables 1
Shared group lost after compacting database 9
Remove Access Security 1

Back
Top