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...
I hope it's clear that the report looks correct in the Designer, it's just a failure to print on paper.
Looking at Search, I found the word "Suppress" and wondered if I had suppressed them without realizing it. But I can't find anywhere that any of the unprinted objects are suppressed
We have a VB.Net application that lets the customer generate 4 different pre-programmed Crystal Reports on the results of our control system. Three out of the 4 reports print up just fine. One of them leaves out certain objects, BUT ONLY ON THE FIRST PAGE of the Report. It's been a long time...
Here's the answer at last! I have to enter the username as
"<machinename>\username"
not just the username by itself.
Such a simple detail!!!
I found the answer on another board where someone had exactly the same problem.
You can make the DataGrid itself unrepsonsive to a Delete with
Dim cm As CurrencyManager = CType(Me.BindingContext(DataGrid.DataSource, DataGrid.DataMember), CurrencyManager)
CType(cm.List, DataView).AllowDelete = False
I found that in the documentation a long time ago and use it whenever I...
If I set it to
ServiceProcessInstaller.Account = System.ServiceProcess.ServiceAccount.NetworkService
the Service starts and then stops, with a message saying it has no work to do (?????)
If I set it to
ServiceProcessInstaller.Account = System.ServiceProcess.ServiceAccount.LocalService
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.