I've been doing a huge amount of programming and updates to my database and now I'm running into the problem where I cannot update my DB because users are keeping it open when they go home for the evening.
Does anyone have some VB that will close and shutdown the DB if the user has it idle for a given time?
This DB does not allow the users to add or edit data, it only provides graphs and trends for a thermal plant operation. PLC's are sending data to a SQL DB and Access is used for my front end.
Any help would be appreciated,
Mike