I
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
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