Got a slight problem that really needs to be addressed...
In our factory we have a couple of computers setup, that the staff out there can perform various operations on. But because of the sheer amount of data that is being handled, and accessed in the back-end at any one time, the back-end becomes quite bloated, and therefore starts getting a little sluggish.
I know that I can't be the first person to encounter such a problem. I also know that doing a simple compact and repair (or using a .bat file, which is what I actually use) will clear it up. The issue being though, that to perform that on the back-end, I have to go around to all the PC's and log them out of the database. This is obviously a huge pain, and as we're expecting to move soon, as well as scale up both the business and the database, the problem is only going to get worse.
What I'm looking for is a script that can be run from somewhere (don't really care where), that upon my command will terminate all open clients accessing the database, so that I can compact it to its more regular 20MB filesize.
The only way I can think of achieving this is messy, and involves Java and sockets, and all sorts of stuff that I don't want to have to program if there exists a much simpler way to achieve this goal.
Just so you know the network infrastructure:
QNAP SERVER - Database Back-end
Wired Network - Utilising two 20 socket switches and a couple of routers
6 Workstations (at the moment) - Individual Database Clients (Front-end)
Any ideas and/or experience from people who have encountered similar issues?
Thanks in advance guys.
PS: Same goes for the need to add tables, change data types, rename columns, all that jazz too...