Run-time error '3137':

[Middlemarch]

I'm getting error
Missing semicolon ( at end of SQL statement.
But there is, so it must be something else ?

sql = "UPDATE flacTracks SET flacTracks." & Combo0 & " = " & Chr$(34) & Contents & Chr$(34) & " Where (ttrack between " & Dat(0) & " and " & Dat(1) & ") and TCat = " & ThisDisk() & " Order by ttrack ;"
CurrentDb.Execute (sql)

UPDATE flacTracks SET flacTracks.Path = "Greatest Hits & Favorites CD 1" Where (ttrack between 124 and 143) and TCat = 1017 Order by ttrack ;

[June7]

An action SQL should run just fine without semi-colon.

There is no need for ORDER BY clause in any action SQL, really serves no purpose. In fact, I just confirmed that is cause of error.

Should not need to prefix Path with table name but doesn't hurt.

Are ttrack and tCat actually number type fields?

[Middlemarch]

Thanks June, it worked perfectly with those changes
Yes, those two are number fields.