JohnnyTwoTone
Programmer
I'm trying to set up a program that monitors how our database server is doing on a day to day basis. I've set up the program to sit up on top of the screen like a task bar, and can hide and such, and when it's pulled down, it shows all the information as far as stats go for our database server. Now, at the end of the day, I would like to put all the totals that have accumulated into an Access database that I can then link my Crystal Report Viewer and Executor into, and then run reports on monthly statistics and such. How would I go about doing this? I would set it up with a Command Button to "close the day" and send all the information I have put into variables into fields of an Access Database. However, I don't want the user to see the database itself, because that can lead to some liability issues. Is there a way to send all that information without the user ever seeing it? I'm not very familiar with using Access databases, so please use very very blunt terms.
