Access DB loosing Full control rights

[i.sobha]

Hi,

I have an access DB, when a user access the DB from the front end, he
is given permission to modify some tables in the DB. For modifying the
data in the table he has to have full control to the DB. For giving
full control, the following DOS commands is executed as a part of a
sheduled task.
cacls C:\test\TestDB.mdb /e /g everyone:f

On viewing the Security Properties of the DB after executing the above
command a group "Everyone" is added which has got 'Full Control' on
the DB and any user accessing the DB from the front end can make any
changes.

But, Nowadays some problems are encountered. After a couple of hours
after executing the DOS command the DB seems to loose the full control
right and the group "Everyone" is getting removed from the Security
Settings. Due to this reason users at the front end is getting Page
cannot be displayed errors.

Can anyone please give any help on why the access DB is loosing the
Full control access?

Thanks in advance
Sobha Indiradevi

 

[Joan Wild]

My guess would be that the database is getting compacted. When this happens a new copy of the file is created (and this copy will inherit permissions from the folder).

 

[i.sobha]

Actually, compacting the DB happens at around 9:00 PM everyday where
the access DB is compacted and the security rights is assigned to the
DB just after compaction (It is a scheduled task).
The command used for compacting is
cacls C:\test\TestDB.mdb /e /g everyone:f

And every day morning at around 10:00 AM a scheduled task is run to
insert the days data into the DB. After inserting data again security
rights are set using the same command.
cacls C:\test\TestDB.mdb /e /g everyone:f
Just after inserting data comapction is not done. Compaction happens
only in the night at 9:00 PM