To follow up, it turns out that the network administrator had changed the login account used by the SQL Server services from Administrator to Local System. Changing the Agent...

Thanks! I'll have to try and process that in the morning, as my brain is fried.

Hi "B"! The same SQL for both other than the table name:

UPDATE Driver_summary

SET Driver_no = Replace(Driver_no,' ', ' 8')

WHERE substring(Driver_no,5,1) = 2

The driver number...

As an update, and because I'm up against a time problem, I experimented with taking the trigger out temporarily, then running the update query against the parent table first and...

What you say makes sense, but I'm not sure what you're suggesting as the alternative. The trigger has been in place a long time, but I could certainly disable...

Thanks for replying Gail (and greetings from an Access MVP). I thought it looked odd that there were no joins. The car table has an additional field as...

I appreciate the response and the info. I don't like the info, but I appreciate it. 😛

Just wanted to say thanks Sean. I followed your recommendation and have a holding table populating from the trigger and a stored procedure that uses a cursor to loop...

There could be a delay, but it would be measured in minutes rather than hours. The status field is used to let dispatchers know whether they can give the...

I appreciate the information and I'm always looking to improve. That said, it doesn't address my issue of executing a stored procedure on a linked server. I can't...

Sure, the existing trigger is below. No cursor, and I can't imagine more than a single record being updated at a time. But being a novice I may...

Thanks Jason. I think over time applying the date criteria first would be most efficient, but wouldn't having to apply string functions over the entire table be costly? ...

Thanks Craig, I appreciate your thoughts and the speedy reply. If I'm reading correct the best performance might be:

SELECT...

INTO #Whatever

WHERE DateCriteria

then

SELECT...

FROM #Whatever

WHERE StringCriteria

I appreciate your quick reply. I will do that research. The DatePart() function in Access has arguments that let you control this (specifically the "firstweekofyear" argument). I...

Thanks GilaMonster. I had actually searched on the problem and tried something similar to that, but didn't include the "GO" lines. Fundamental lack of understanding of how SQL...