Shared group lost after compacting database

[Sister Jeannine]

I am using XP Pro and Access 2000. I have set a user group
at the file level with permissions to "modify" the database
and an Administrator group with full control. After
compacting/repair the user group with the modify
permissions is gone.
How do I set permissions at the file and folder level to
remain after compact/repair.
Thank you

 

[TC]

You can not successfully use file & folder security with an Access database.
Unless the database is opened in Access "exclusive, read-only" mode, >every
user< must have full permissions to the MDB file (afaik) & the folder in
which that file resides.

HTH,
TC

 

[Sister Jeannine]

TC,
Found a way. When Access compacts and repair it soes it in
the the temp folder of the user's profile. You have to set
permissions for the group to modify in this folder and then
it works. When Access is finished compacting and repairing
the database, it then moves it back to its original
location. I have a peer-peer network so one machine does
the compacting. I set the permissions on my user file and
gave the group permissions on the Documents and
settings/"profile name"/Local Settings/Temp. It works.
Thanks for the help. I hope this answers others who may
have tried the same thing.

 

[Joan Wild]

That is interesting. I just tested on a few databases, and all of them
compact in the same folder as the mdb. None of them used the temp folder.

I'm not sure why it would do so on your machine, but if it's working, that's
great.

 

[eacollie]

I believe it creates a temporary file during the
compact/repair process in the user's profile temp folder,
then moves it over to the original location, overwriting
the original mdb.

 

[Joan Wild]

But that's what I'm saying - it does not do that on my machine - the
temporary file is created in the same folder as the mdb, and is deleted when
done.

 

[eacollie]

Are you set up with user profiles?

-----Original Message-----
But that's what I'm saying - it does not do that on my machine - the
temporary file is created in the same folder as the mdb, and is deleted when
done.

--
Joan Wild
Microsoft Access MVP




.

 

[Joan Wild]

Yes I am. There is nothing happening in the
Documents and Settings/Joan/Local Settings/Temp
folder. The temporary db1.mdb is created/deleted in the same folder as the
mdb.

 

[eacollie]

I guess it depends on the version of Access...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;295234&Product=acc

 

[Joan Wild]

I guess it depends on the version of Access...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;295234&Product=acc

Thanks, I was not aware that 2000 behaved differently.