I have a table with 20.000 records (persons).
Users on four or five computers insert, update or delete records but must at all times have access to real-time data.
If a user on a computer marks a person with a flag, or inserts a new person, all the users must see that in real-time.
Is there a way ?

I'm using a datagridview to display the information from the persons table.
Any suggestions please ?

A stupid solution was to execute a query on each rowenter event of the datagridview and retrieve information directly from the table and display it in text fields, but that does not solve my problem with the inserted records.