I have a program in Access that uses SQL Server.
I have many reports that are based on an existing pass-through query that executes a Stored Procedure. Just before I open the report, I modify this query with the correct Stored Procedure and parameters. This has all worked well until recently.
There can be a dozen or more people using this program. Two people were printing different Customer Invoices at the same time. The same Invoice printed for both and a Customer ended up getting the wrong invoice. The query was modified by the second user before the report was printed for the first user.
I’ve been searching and found other solutions, but they only work for ADP.
Is there a way to prevent this problem from happening?
Thanks