I have also thought of adding something to the Service to periodically compact the database. I know of code that will do it, but I am worried about conflicts. The Service is driven by receiving messages from the host machine through a MessageQueue. I believe that compacting requires exclusive...
I guess I need to learn about how data types get stored in an Access 2003 database. We use Access to store configuration data and system activity data for an alerting system that we sell. It has always served our needs just fine, no need for anything bigger or more powerful. The configuration...
Interesting response on another forum:
***************************************************
Typically the next time the system opens and attempts to run any action query you get an error message that says "Invalid Argument".
When Access runs any action query it initially attempts to replicate...
One of the system components, a touch-screen "Master Station" computer running XP, used for starting alerts and displaying icons for all the locations that beep in an alert, accidentally got a second instance of its software started. The customer somehow managed to minimize the application and...
We make an alerting system that has an admin station, a Dell workstation running XP, that monitors system activity and stores stuff in an Access 2003 database. Something on the system ran wild a week ago and it spewed out a continuous stream of error messages and we found the database at a size...
Is the Tick event from a System.Windows.Forms.Timer? That's the only Timer with a Tick event that I have found so far. Would that work in a Service?
And still, it seems like solving the problem of the effects of the runaway (good trick to even keep the log from bloating), and leaves the timer...
I'm not clear what your idea is. You still have a timer, yes? What type of timer is it? The two I know of are System.Timers.Timer and the type in my app, System.Threading.Timer.
Are you saying that at the timer event, I could avoid the runaway effect by comparing to some variable and only...
There are 2 places in my application where I use a System.Threading.Timer. The app is a Windows Service, and is deployed at several customer sites, where it runs continuously.
One timer is used to send a "Keep Alive" email message once every hour. When called, the delegate kicks off the...
It looks like the VB.Net code (System.Data.OleDb) that I've used in my Windows Service for a long time has been opening the Access 2003 database for queries in Exclusive Mode. I did not set that explicitly in my ConnectionString, I didn't even know it would matter. I'm not a database...
I want my VB.Net application to have a button that the user will click to open a browser window, and call the webpage I designate in code. The system is a closed network, no Internet access, but with a webserver on another machine to serve the page I want, which will be used for configuring the...
Well, I found what was apparently happening, but I have no idea why. I was looking at the problem the wrong way. Instead of thinking "this object is able to print, what's wrong with the others?" I should have asked "is there something about this object that makes the others not print?" I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.