Repair while database is shared

[Nikopico33]

Hello,

I have the following problem.
when a database is corrupted I can't open it to make compact and repair unless every user have the database closed.
Is there a way to compact and repair without going to every user and tell him to close the database?

Best Regards,
Ricardo

 

[DJkarl]

In short the answer is no. Part of the compacting and repairing process is to delete the old database, this can't be done unless everyone is out of it.

 

[odin1701]

Read up on using a front end/back end solution.

In this way, the back end with the data should not get corrupted (do a daily compact/repair on it before anyone starts work).

If the front end on the users computer gets corrupted, you simply replace it and that's all.

 

[Nikopico33]

Ok, thanks for the answer. It's not what I would like but now I know that I do not have solution and have real to split the database...

Thanks!
Best Regards,
Ricardo

 

[cooh23]

Hello,

I have the following problem.
when a database is corrupted I can't open it to make compact and repair unless every user have the database closed.
Is there a way to compact and repair without going to every user and tell him to close the database?

Best Regards,
Ricardo

what you are looking for is the auto logout feature. I have it in all of my databases. It makes it so much easier to log everyone out. Search for "Force Logout or Kick off". Good luck

 

[Nikopico33]

"Force Logout or Kick off".

I already found something that is what I need. Thanks for the tip!