Compacting db
- Thread starter superrob5
- Start date
I see. I have a questoin. I have a db that is on a network and would like to compact. Is it best to automate and if so is there a way to automate them when noone is on the db. Is there a way to test to see if the db is opened on another computer. But I guess the safe way is to wait til the evening and do compacts manually???
Rob
Rob
Newman
Québécois
- Local time
- Today, 17:14
- Joined
- Aug 26, 2002
- Messages
- 766
To automate, you got to make sure no one as left office with the db open. (There is thread about how to disconect users in this forum...)
Then, create a task which opens the disconnection script and a vbscript at midnight with something like this: (Not sure of the syntax thaugh...)
With the mdb file, you'll see a ldb file when someone is connected.
Opening it with notepad will even show you who has visited the db. (Not actualy on it, but has visited) The ldb file disapears when every one has log off.
It may sound a bit complicated (It is!), but that's all I can tell you now. I've done it with the help of other members of this forum. Search thru it and you shall find more answers.
Good luck!
Then, create a task which opens the disconnection script and a vbscript at midnight with something like this: (Not sure of the syntax thaugh...)
Code:
Shell.Run """" & AccessPath _ & """ """ & SourceFolder & "\" & ProgramFile _ & """ /wrkgrp """ & SourceFolder & "\" & SecurityPath _ & """ /compact /user """ & Username _ & """ /pwd """ & Password & """", 3, TrueWith the mdb file, you'll see a ldb file when someone is connected.
Opening it with notepad will even show you who has visited the db. (Not actualy on it, but has visited) The ldb file disapears when every one has log off.
It may sound a bit complicated (It is!), but that's all I can tell you now. I've done it with the help of other members of this forum. Search thru it and you shall find more answers.
Good luck!
Similar threads
