UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Compact And Repair, Access 2016    
 
   
meyert
post Oct 10 2018, 05:57 AM
Post#1



Posts: 125
Joined: 22-January 08



Hello

I have a database that is split. I try to routinely compact and repair the back end of the file to keep things from getting too large. My problem is that sometimes its hard to find a time when no one is using the file to compact and repair

Am I correct to believe that I have to wait until the file is not in use to compact and repair? I have tried at a time when I believe others are in the file and I get errors, but I am not sure that is the root cause. But the issue is resolved easy enough

Please let me know your thoughts

Thank you
Go to the top of the page
 
BruceM
post Oct 10 2018, 06:39 AM
Post#2


UtterAccess VIP
Posts: 7,683
Joined: 24-May 10
From: Downeast Maine


There are several ways to kick users off of a shared database (or several if more than one is open). The KickEmOff2K file at this link is one option.

It is true that Compact and Repair can only be done when there are no other users.
Go to the top of the page
 
meyert
post Oct 10 2018, 07:01 AM
Post#3



Posts: 125
Joined: 22-January 08



Thank you so much. I will check out the kick'em out link ohyeah.gif
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th October 2018 - 09:39 PM