Compact and repair messes with user access

[sudhirhinduja]

Hello,

I am trying to do a compact and repair on my database but when I do that I find that my database which is on the server is not recognized by the 9 other client machines.

My shortcut which uses a workgroup file is on each machine and was working fine until yesterday. Once I perform a compact and repair the clients say that they cannot find the file on the server.

Howcome the compact and repair operation is screwing up with the accessibility of the file?

Please advise.

Thanks,

 

[Uncle Gizmo]

Right, the way I understand it and I must qualify that by saying I don't know if this is Absolutely correct so I would prefer confirmation from somebody else! But I believe what happens is, when you compact and repair a new database is created, usually something like db1.mdb, and then the old database is deleted and the new database renamed. Like I said, I would like confirmation on this I wouldn't know how to go about getting it though. It might be on the Microsoft site, it may tell you what happens in a compact and repair routine.

If your users are connected to the database when you compact and repair, then it is going to cause some problems! I would be surprised if you can compact and repair if somebody else is connected to the DB though.