Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schedule Compact, Disconnect Users

Status
Not open for further replies.
des0906

des0906

IS-IT--Management
Jul 30, 2001
69
US
I am attempting to setup a scheduled compact for a database I have been working on. Essentially, it is a back end db used by multiple users. If I want to run a nightly compact and repair, I realize that I need to have the users disconnected. What is the best approach for this?

Thanks.
 
Status
Not open for further replies.

Similar threads

Darrylles
  • Locked
  • Question
WScript / MS access db compacting
Replies
1
Views
213
lameid
lameid
TinyNinja
  • Locked
  • Question
How can I automate compacting?
Replies
0
Views
133
TinyNinja
TinyNinja
JoyLopez
  • Locked
  • Question
VBA code working for me but not for users
Replies
4
Views
151
lameid
lameid
razchip
  • Locked
  • Question
Email users with report
Replies
8
Views
172
razchip
razchip
PercyN
  • Locked
  • Question
Compact a password protected backend
Replies
5
Views
121
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top