Repair/Compact Changes Security settings?

[Ken Winters]

Whenever I run the Repair/Compact on my database, the security settings on
the file change.

A 3rd party application can only access the database over the network when
the username "Everyone" is added to the "Group or user names" with access to
the file. But each time the Repair/Compact utility is run, it removes
"Everyone" from the list.

This is under Win2000. Can anyone offer some advise or suggestions?
Thanks

[Rick Brandt]

Ken Winters wrote:

Whenever I run the Repair/Compact on my database, the security
settings on the file change.

A 3rd party application can only access the database over the network
when the username "Everyone" is added to the "Group or user names"
with access to the file. But each time the Repair/Compact utility is
run, it removes "Everyone" from the list.

This is under Win2000. Can anyone offer some advise or suggestions?
Thanks

Compacting is actually done by creating a NEW file so it will inherit the
permission settings of the folder the file resides in.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Ken Winters]

I wish it were that simple. I already set the folder security to grant
access to Everyone. If I do a simple copy/paste of the file (or create any
new file in the same folder), it has "Everyone" in the access list. But
when I do Repair/Compact it changes so that only System Administrators have
access.

Thanks
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:39*************@individual.net...

Ken Winters wrote:

Whenever I run the Repair/Compact on my database, the security
settings on the file change.

A 3rd party application can only access the database over the network
when the username "Everyone" is added to the "Group or user names"
with access to the file. But each time the Repair/Compact utility is
run, it removes "Everyone" from the list.

This is under Win2000. Can anyone offer some advise or suggestions?
Thanks

Compacting is actually done by creating a NEW file so it will inherit the
permission settings of the folder the file resides in.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[John Mishefske]

Ken Winters wrote:

I wish it were that simple. I already set the folder security to grant
access to Everyone. If I do a simple copy/paste of the file (or create any
new file in the same folder), it has "Everyone" in the access list. But
when I do Repair/Compact it changes so that only System Administrators have
access.

Thanks
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:39*************@individual.net...

Ken Winters wrote:

Whenever I run the Repair/Compact on my database, the security
settings on the file change.

A 3rd party application can only access the database over the network
when the username "Everyone" is added to the "Group or user names"
with access to the file. But each time the Repair/Compact utility is
run, it removes "Everyone" from the list.

This is under Win2000. Can anyone offer some advise or suggestions?
Thanks

Compacting is actually done by creating a NEW file so it will inherit the
permission settings of the folder the file resides in.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Is this with Access 2000? I believe that is the only version of Access
that copies the file to the TEMP directory first instead of the current
directory during a compact. The permissions get modified because of
this. I recall this issue but don't recall the fix. Perhaps you should
open up the permissions on your defined TEMP directory.

--
'---------------
'John Mishefske
'---------------

[Ken Winters]

That was it! Thanks

"John Mishefske" <mi************@JUNKtds.net> wrote in message
news:42**********@newspeer2.tds.net...

Ken Winters wrote:

I wish it were that simple. I already set the folder security to grant
access to Everyone. If I do a simple copy/paste of the file (or create
any new file in the same folder), it has "Everyone" in the access list.
But when I do Repair/Compact it changes so that only System
Administrators have access.

Thanks

Is this with Access 2000? I believe that is the only version of Access
that copies the file to the TEMP directory first instead of the current
directory during a compact. The permissions get modified because of this.
I recall this issue but don't recall the fix. Perhaps you should open up
the permissions on your defined TEMP directory.

--
'---------------
'John Mishefske
'---------------