hi,
i have some problems with my msde/sql express database located on an inet server (p4 2,4ghz, 1024mb ram, 100mbit broadband connection).
i have about 10 clients out there which connect every 15 minutes do the db to do some processing...mostly performing select commands which seems to run fine!
i have one admin tool to fill the db with records here at my office and sometimes when i am performing an update or insert command it just timeouts...i then have no chance to edit records! just a few records seem to be blocked, because some work like always!!
sometimes after a few minutes everthing is ok again...sometimes it takes hours
what is causing this? pleas help
greets
matthias