Compact/Repair and Network Use

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)



Vel said:
Hello,

I've discovered a problem. I use Access2000 over a local network using
Click to expand...
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
Click to expand...
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.
 
Back
Top