I've read a past thread about the way the locking is occuring based on APPEND BLANK, INSERT SQL, etc. There was a mention that INSERT SQL is better to use.

I use INSERT SQL a lot, for robot applications - not for desktop applications, and have found that sometimes, collisions occur. So, at the same time, the same INSERT SQL is executed by 2 applications. The 2nd one will have "File is in use by another user". What will be the best way to handle this so we can make sure that each application will process this locking in a queue?