HI. I have a shared access database that tracks returned goods and actions taken\pending. I had some old email code that sent a separate email to each user where action was required. This means a lot of email processing. I am changing that to send out a single distinct email for action users and they can now log into the database to view a report showing their specific actions. To make this possible, I turned all of the email alert code into a series update queries that write to a table called RGAlerts. I can run the refresh manually but I'd really like to refresh it each time the users either open or close the report, I'm not sure which would be best. I have all of this working except for the report-driven table refresh. I'm concerned about user updating simultaneously. It would only hurt this one table that will get refreshed anyway but I think it could cause some confusion as that table could show duplicate entries if users happen to trigger the refresh at the same time..
What is a good way to manage simultaneous updating in ACCESS 2010 and 2016? Both clients are in place. Is record locking possible to use in this situation?