I think there may well be a more general solution that doesn't involve tracking who has what open. I presume you are using ODBC linked tables in your Access front-end, though you don't indicate that. If you add a "timestamp" field at the end of each of your SQL Server tables, and then relink the tables, you should no longer get the write conflict errors. This isn't documented well, but it's something we adopted over 10 years ago and has worked well for us.