I am writting a piece of code that updates my databases
when i put a txt file in a certain folder.
The presence of a new file triggers a code that reads the file, update the DB and put the file in an Archive folder.
On the other hand i use a client access to the program.
I access the DB very frequently.
My problem: it happens that i get records containing old records in some fields and new ones in other fields because the system is updating in the background my DB.
The solution seeked:I need to be able to block the refresh screen = F5 when the DB is being updated.
Is there a simple piece of code that can lock refresh and ulock it moments later?
I will definitly grade the best answer!