I have an Access database that contains orders that need to be
processed. The users of this database use an Excel spreadsheet to
access the database. Basically, what I'm trying to accomplish is when
a user asks for a new order, the SQL query hits the database, locks
the record, assigns the record to the person requesting it, pulls the
info to excel and displays it. Here's the SQL statement:

strSELECT5 = "SELECT * from [RES LNP Production Table] [Readpast]
WHERE [LNPSpecName] is NULL ORDER BY [LSRSentDate];"
' New/Unassigned orders

What is happening: When simultaneous requests are made, users are
getting the same record. I thought that Readpast would skip the locked
records. What am I doing wrong?