Compact/Repair and Network Use

[Guest]

Hello,

I've discovered a problem. I use Access2000 over a local network using WinXP computers. Everything works fine, until I compact/repair a database. At that time, no remote users can access that database any longer. I can't figure out why. Right-clicking the file gives me no options about 'permissions' and the folder permissions all seem to be set appropriately. Now, just so you realize the strangeness of this problem, if I move the file into any other folder, compact/repair, and move it back to the original folder, it works fine. On the other hand, if I was to then move it back into the folder where I did the compact/repair, and update the user's front end to look for the backend in the new location it would be unable. I get an error about not being able to find the file, or the file being opened exclusively by another user.

Just for clarification:
This always happens if I compact/repair, it is not an isolated incident.
This happens regardless of the computer i use to serve the backend.
There are no hidden files to delete.
I have only been able to workaround the problem by compact/repairing in a different folder and then moving the file back to the original folder. If I accidentally compact/repair a file in the original folder I need to delete and recreate the folder before users can access the backend again.

Thanks,

Vel.

 

[Douglas J. Steele]

What are the permissions on the folder where the MDB exists? Are they
different than on the MDB itself?

You might want to read what Michka says at
http://www.trigeminal.com/usenet/usenet028.asp

He's also got code you can use to copy permissions from one file to another
at http://www.trigeminal.com/codes.asp?ItemID=25#25


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello,

I've discovered a problem. I use Access2000 over a local network using

WinXP computers. Everything works fine, until I compact/repair a database.
At that time, no remote users can access that database any longer. I can't
figure out why. Right-clicking the file gives me no options about
'permissions' and the folder permissions all seem to be set appropriately.
Now, just so you realize the strangeness of this problem, if I move the file
into any other folder, compact/repair, and move it back to the original
folder, it works fine. On the other hand, if I was to then move it back
into the folder where I did the compact/repair, and update the user's front
end to look for the backend in the new location it would be unable. I get
an error about not being able to find the file, or the file being opened
exclusively by another user.

Just for clarification:
This always happens if I compact/repair, it is not an isolated incident.
This happens regardless of the computer i use to serve the backend.
There are no hidden files to delete.
I have only been able to workaround the problem by compact/repairing in a

different folder and then moving the file back to the original folder. If I
accidentally compact/repair a file in the original folder I need to delete
and recreate the folder before users can access the backend again.