Updating Database At Regular Intervals

[nh_capricorn]

Is there a way to update my database at regular, small intervals (say every 15 seconds)? I was looking at a number of FTP tools to do this, but the smallest time increment they have is one minute. Are there any other tools that provide this type of fine control?

If not, what is the best way to do this?

Thanks!

[Scott]

When you say "updating", what is it, exactly that you want to do. Are you adding, deleteing, or changing data every 15 seconds?

[bruce]

If you are trying to replace the MS Access file in like a 15 s interval, i do not recommend it.

You will run into so much locking problem that either your FTP or web application will fail.

Remember, Access and file based db (text) uses lock to maintain integrity. ie. if something has the db open, other application cannot overwrite it.

[b]quote:Originally posted by nh_capricorn

Is there a way to update my database at regular, small intervals (say every 15 seconds)? I was looking at a number of FTP tools to do this, but the smallest time increment they have is one minute. Are there any other tools that provide this type of fine control?

If not, what is the best way to do this?

Thanks!
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET