How to handle scenarios where multiple users are processing the same file at the same time

tom-jerry 0 Reputation points
2025-04-27T17:09:20.3166667+00:00

I have a button on MS access form which when clicked, goes to a network drive and reads a json file and process it. This form will be used by multiple users at the same time. I need to handle scenarios where if multiple user clicks on the button simultaneously should not lead to error. Not more than 1 user should process the json file at the same time. Only 1 user should have access to processing the json file at a time. Can anyone suggest some ways to handle such scenarios. Programming language used is VBA. Also has access to SQL server.

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,837 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.