>I can't use an autoinc field because the table in question stores counters for a variety of different processes in the application. I need a way to ensure that each process can get a counter from this table and update it by 1 so that the next process will get the next number.

Check my other response on this thread.