Vacation is vacation. You could be anywhere on the planet, with an empty battery.

Is the exe on a local drive (E:...)

or a network drive \\otherserver\myexe (not accessable by local machine)?

You could check hardware logs/application logs.

You could create views/storedprocedures on DB2 for the data you need to fetch from DB3.

Error handling in sql 2000 is a tricky process.

You have to evaluate after each statement. Some errors immediately abort the batch.

statement

/*saving the error*/

@myvar=@@error

if @myvar<>0

BEGIN

doerrorhandling

END

statement

@myvar=@@error

if @myvar<>0

BEGIN

doerrorhandling

END

Inside the...

Perhaps a security issue of sqlagent. What is its windowsaccount? Local machine, ...

Is the update being done with .Update (can be slow) or with an update-sql statement?

Adding some code to quickly scroll to the bottom and back up?

It is affected by the number of records.

Do you have a covering index on (stime,savg) to avoid bookmark lookups?

High CPU/memory usage can also be caused by massive full table scans.

SP4:

+bugfixes

http://support.microsoft.com/kb/888799

+better corruption/blocking detection

-has an intial bug with AWE (additional hotfixes needed)

-changes index seeks (needs exact typing char(20)vs char(20) etc, to eliminate some false results)

There is also a cumulative post SP4...

the tables"inserted" and "deleted" only exist inside the trigger.

Your code seems to work correctly.

I've tested your code (in tempdb) with

DECLARE @ProjectID int

DECLARE @TimeEntryStart datetime

DECLARE @TimeEntryEnd datetime

DECLARE @TimeEntryUserID int

SET @ProjectID=35

SET @TimeEntryStart=convert(datetime,'2008-04-14 02:30:00.000')/*RETURNS 1*/

SET @TimeEntryStart=getdate()/*returns NULL*/

SET @TimeEntryEnd=NULL

SET @TimeEntryUserID=1035

SELECT [tempdb].[dbo].[f_TimeEntryOverlap]

(@ProjectID, @TimeEntryStart,...

I guess so. You can find sp_who2 in the master database and it is marked as system.

try Me.TabControlRiskForm.Pages(1).enabled = false

instead of

Me.TabControlRiskForm.Pages(1).Locked = True