Compacting and File system security problems

[jgrayek]

Hi

I've done every search I could think of, but haven't come up with a solution.
I'm having a problem with file system security settings of windows 2000.
I have a FE/BE database setup, the BE is stored on a network drive that all users have access to. The FE is stored in the same spot on every workstation (C:\data\XXX\XXX.mdb). The FEs demonstrate considerable bloat and I understand that the solution is frequent Compact and Repairs.

However, each physical workstation is used by more than one user (different shifts) and the compact process removes the Everyone file system access from the database and replaces it with Administrators, and the current user; thereby preventing anyone other than the compacting individual from accessing the FE on that computer.

Is there a solution??

thanks
Jesse

 

[Bat17]

I belive it comes dow to security setttings in your OS. When you compact Access it creates a new file and delets the original then renames the new to match the old. You need to set up the way that new files get security added and I cant help with that bit, but hopefully someone else can.

peter