LeadBroadCast
IS-IT--Management
Scenario:
I have a table that is updated from an online application. My local db checks for new values every 5 minutes. I have a program that loads any new data posted from online to a local table here on my deskttop.
What I've noticed is that when there is a value posted to this local table, my update processes run much slower. Is there any way to speed this up?
Also, the macro I run for these processes will run for a few hours on a timer...but then I get Invalid Arguement error. I then have to shut the db down and compact/repair to get this to work again. Maybe a clue.
Thanks!
LeadBroadCast
I have a table that is updated from an online application. My local db checks for new values every 5 minutes. I have a program that loads any new data posted from online to a local table here on my deskttop.
What I've noticed is that when there is a value posted to this local table, my update processes run much slower. Is there any way to speed this up?
Also, the macro I run for these processes will run for a few hours on a timer...but then I get Invalid Arguement error. I then have to shut the db down and compact/repair to get this to work again. Maybe a clue.
Thanks!
LeadBroadCast