I've created a split db with the be on a shared server and fe on each users desktop. I have tables for the users to search using criteria they input into the form.
When they press a 'search' button, it runs the query against the tables and finds the data based on their criteria and only provides results based on their criteria.
The issue is when 2 or more users press the 'search' button at the same time, the results output on the form from the query are combined. How can I keep the search (query) results separate? Thanks!
When they press a 'search' button, it runs the query against the tables and finds the data based on their criteria and only provides results based on their criteria.
The issue is when 2 or more users press the 'search' button at the same time, the results output on the form from the query are combined. How can I keep the search (query) results separate? Thanks!