File sharing disabled after compact & Repair On XP

[Guest]

Has ayone else noticed that a Backend File placed in a
shared folder with full read / write permissions on a
windows XP network becomes inaccesible after the compact &
repair routine is performed on the backend file. The only
way I have gotten around this is copying the file to a new
folder, re-naming the folder and sharing the new folder.
This seems like a prety big glitch with XP, it never
happends with Windows 2000. Any insight ??
Thanks

 

[Wayne Morgan]

The compact and repair works by creating a new file that Access compacts
into then copying that file over the current one. If that temporary file is
created in a directory with restrictive NTFS permissions, when it is copied
back it may keep those permissions instead of picking up the permissions of
the directory it is being copied into. Since creating a new directory seems
to solve the problem, this may be what is happening. I tried looking but
didn't see the file created in the current database directory, %temp%
directory, or %windir%\temp directory, so I'm not sure where this is being
done.