Trying to create multiple instances of a standard exe program that will be accessing the same database.

How should the database be managed?

Because when one instance of the program deletes a record in the database and another instance tries to edit the same record, it will cause problem.

Was thinking of using "app.PrevInstance" property to detect if another instance has been created and lock the database to be a read-only grid.

But how would it be possible to detect that the first instance has released the database?

Is there any other help available?

Thank you.