Repair and Compact, domain users lose all rights

[kiln]

I am working with a network that is remote to me (I dial in with vpn and
RD). I've not seen this ever before, but when I do a repair and compact
on the db backend mdb file (access 2000 all service packs) the user
group "domain users" vanishes from the files permissions dialog. Each
time I have to add it back in, and all full control. This network has a
pretty skillful network admin managing it, but he doesn't have any idea
why this might be occurring and isn't showing a lot of interest in
figuring it out. Has anyone seen this sort of thing before? Any clues as
to what direction a solution might be found? OS is win2003 server. When
I'm logged in and doing the repair/compact, I have full admin rights.

Thanks

 

[Bill Edwards]

A compact and repair essentially:
(1) Creates a new .mdb that is a compacted and repaired version of the
original
(2) Deletes the original .mdb
(3) Renames the new .mdb to the name of the old .mdb

This results in the loss of permissions.

Apply the permissions at the folder level, not the file level.

 

[kiln]

But, the folder that the backend db is in does have the same full
control permissions set for domain users.

 

[Bill Edwards]

Maybe this will help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;295234

 

[kiln]

Bill thanks for that pointer, I think that's going to be the ticket.