The Access DB is used in 12 users shared environment.
I have a macro which run code to insert record into table.
Since multi users could run the macro at the same time.
Is there any way, that I could give messge to the user "Please run it later" if the other user is running this macro, or maybe could control it to run after the other user finished this macro.
I have a macro which run code to insert record into table.
Since multi users could run the macro at the same time.
Is there any way, that I could give messge to the user "Please run it later" if the other user is running this macro, or maybe could control it to run after the other user finished this macro.