Outrageously long update time

[MacroScope]

I have a table that has 50,000 records in it. I'm running an update query that updates only one field. The update is to proper case, so essentially the update is Proper([Make]). Seems simple enough, but it's been running for 45 minutes and is not finished yet.

What can take so long?

By the way, this is not the only update that takes this long. Other simple updates of a lot of records are equally slow.

It's Access 2007 on SQL Server 2012.

Thanks in advance.

 

[dhookom]

If all the tables are SQL Server, you should consider using a pass-through query which will take a second or two.

UPDATE [YourTableName] SET Make = UPPER(Make) WHERE Make Is Not Null

Duane
Hook'D on Access
MS Access MVP

 

[MacroScope]

I never got a notification that there had been a reply to this thread, or I would have acknowledged it. Thank you, even if it's belated. I'll give this a try shortly.