We have an Access 2003 database that we backup every week on a floppy for
offsight storage. Hence, we need to compact & repair this database every few
weeks or so. However, whenever we do a Compact & Repair, the users group
that is assigned FULL ACCESS to the file, is REMOVED from the Security
properties of that file. Once we re-add their group and grant full access,
they are fine until we compact it again. I know this should not be
happening. Does anyone know why a compact & repair would remove a users
group's rights? Any help would be greatly appreciated. Thanks in advance.

Hi.

> Does anyone know why a compact & repair would remove a users
> group's rights?

Yes. The problem is your operating system, not the compact and repair from
Access or Jet. Please see Michael Kaplan's article, "Access/Jet Compact and
NT File Permissions!" on the following Web page:

http://www.trigeminal.com/usenet/usenet028.asp?1033

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.


"Jspagnoli" wrote:

> We have an Access 2003 database that we backup every week on a floppy for
> offsight storage. Hence, we need to compact & repair this database every few
> weeks or so. However, whenever we do a Compact & Repair, the users group
> that is assigned FULL ACCESS to the file, is REMOVED from the Security
> properties of that file. Once we re-add their group and grant full access,
> they are fine until we compact it again. I know this should not be
> happening. Does anyone know why a compact & repair would remove a users
> group's rights? Any help would be greatly appreciated. Thanks in advance.

To be frank, I eally am not sure how to do what you are suggesting. This
problem was thrown to me, so I am looking for an easy fix, if there is one.
If there are any more suggestions, please let me know. I apologize for the
ignorance. Thanks in advance.

"'69 Camaro" wrote:

> Hi.
>
> > Does anyone know why a compact & repair would remove a users
> > group's rights?
>
> Yes. The problem is your operating system, not the compact and repair from
> Access or Jet. Please see Michael Kaplan's article, "Access/Jet Compact and
> NT File Permissions!" on the following Web page:
>
> http://www.trigeminal.com/usenet/usenet028.asp?1033
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as "Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions. (Only "Answers" have green
> check-marks.) Remember that the best answers are often given to those who
> have a history of rewarding the contributors who have taken the time to
> answer questions correctly.
>
>
> "Jspagnoli" wrote:
>
> > We have an Access 2003 database that we backup every week on a floppy for
> > offsight storage. Hence, we need to compact & repair this database every few
> > weeks or so. However, whenever we do a Compact & Repair, the users group
> > that is assigned FULL ACCESS to the file, is REMOVED from the Security
> > properties of that file. Once we re-add their group and grant full access,
> > they are fine until we compact it again. I know this should not be
> > happening. Does anyone know why a compact & repair would remove a users
> > group's rights? Any help would be greatly appreciated. Thanks in advance.

Did you look at the link Gunny provided? Near the bottom (in the "Solutions"
section) is a link to complete code.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Jspagnoli" <(E-Mail Removed)> wrote in message
newsD0DDD5B-7047-4A6D-AA4B-(E-Mail Removed)...
> To be frank, I eally am not sure how to do what you are suggesting. This
> problem was thrown to me, so I am looking for an easy fix, if there is
> one.
> If there are any more suggestions, please let me know. I apologize for
> the
> ignorance. Thanks in advance.
>
> "'69 Camaro" wrote:
>
>> Hi.
>>
>> > Does anyone know why a compact & repair would remove a users
>> > group's rights?
>>
>> Yes. The problem is your operating system, not the compact and repair
>> from
>> Access or Jet. Please see Michael Kaplan's article, "Access/Jet Compact
>> and
>> NT File Permissions!" on the following Web page:
>>
>> http://www.trigeminal.com/usenet/usenet028.asp?1033
>>
>> HTH.
>>
>> Gunny
>>
>> See http://www.QBuilt.com for all your database needs.
>> See http://www.Access.QBuilt.com for Microsoft Access tips.
>>
>> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
>> will be forwarded to me.)
>>
>> - - -
>> When you see correct answers to your question posted in Microsoft's
>> Online
>> Community, please sign in to the Community and mark these posts as
>> "Answers,"
>> so that all may benefit by filtering on "Answered questions" and quickly
>> finding the right answers to similar questions. (Only "Answers" have
>> green
>> check-marks.) Remember that the best answers are often given to those
>> who
>> have a history of rewarding the contributors who have taken the time to
>> answer questions correctly.
>>
>>
>> "Jspagnoli" wrote:
>>
>> > We have an Access 2003 database that we backup every week on a floppy
>> > for
>> > offsight storage. Hence, we need to compact & repair this database
>> > every few
>> > weeks or so. However, whenever we do a Compact & Repair, the users
>> > group
>> > that is assigned FULL ACCESS to the file, is REMOVED from the Security
>> > properties of that file. Once we re-add their group and grant full
>> > access,
>> > they are fine until we compact it again. I know this should not be
>> > happening. Does anyone know why a compact & repair would remove a users
>> > group's rights? Any help would be greatly appreciated. Thanks in
>> > advance.