Compressed mde doesn't inherit the rights of parent

  • Thread starter Thread starter Mark Kirker
  • Start date Start date
M

Mark Kirker

I have a problem when an access 2000 database (mde)
compresses itself on closing, and does not in herit the
rights of the parent directory. When another user logs
into the same pc and trys to access the database, they are
unable to open it. If an administrator logs in and
refreshes the rights it's okay, for the next user to open
it, but of course the same process happens when the user
closes the database.
Does anyone know why this happens, and how to correct it.
 
Hi Paul, thanks for the reply,
Still the same results...here's some more details....

I start with a folder where "Everyone" has full rights,
(no other users listed) "inheritable rights" are ticked on.
I copy the mde to the folder and check the rights.
It has inherited "Everyone" full control, "Allow inherited
rights from parent" is on....all looks ok

Then I run the mde, and close it, (and it compacts on
exit.)
Now I check the rights on the mde...
"Everyone" group is now gone and is replaced with...
Local admin group - Full control
test(Logged in user) - Full control
system - Full control
and "Allow inherited rights from parent" is now off!

When another user logs in (ie testuser2) and tries to run
the database, they don't have any rights, (although they
can see the file) and access says "Microsoft Access can't
find the database file c:\test\database.mde"

Very weird!
 
When you compact a file, the process is
compact to new file
delete old file
rename new file.

If you want the new file to have a particular
right, that right must be given to new files.

So if you want the compacted file to have
"Allow inherited rights from parent"
Then you must set folder so that new files are
given that right.

I'm not familiar with file rights, so I don't know
how to do that, or if it is possible. That question
should be asked in an OS newsgroup.

(david)
 
Thanks David,
I have checked the "Allow inherited rights from
parent" settings etc, but with no avail....I'm going to
check for updates, service packs etc to see if that
helps....
 
Back
Top