Union View locking records
Posted on 2013-12-10
I have an Access front-end for a SQL server database.
In SQL Server I have created a view that is a union query on two of the tables.
The problem is that if a user is displaying the result of that union query, no-one can edit the data in the source tables.
Is that normal?
How can I present the data to one user, while allowing it to be edited by another? In one form the users only need to see one record at a time (although it could be from either source table). However there is another that displays all, so they can be filtered down to the ones that are of interest.