I swear I've done this before, but can't seem to be able to figure it out now. I'm trying to restrict the users from making edits to a query, either from changing the data already entered or from adding new records to the DB. I know how to do this in a form but how do I get it done in a query? Record locks don't work becuase I get this error saying one of my tables is open exclusively, even when it's not. Thanks
Do Not Allow Edits on a Query (1 Viewer)
- Thread starter bmcgree1
- Start date
You really shouldn't be using a QUERY for data entry. In fact, your users shouldn't have access to it at all.
1. Use a form and set its Record Source property to that query
2. Set it's Default View property to Datasheet View.
3. Set the Allow Datasheet View to Yes and set all the other Allow views to No.
4. Set the Allow Additions, Allow Edits and Allow Deletions properties (on the Data tab) of the form to No.
1. Use a form and set its Record Source property to that query
2. Set it's Default View property to Datasheet View.
3. Set the Allow Datasheet View to Yes and set all the other Allow views to No.
4. Set the Allow Additions, Allow Edits and Allow Deletions properties (on the Data tab) of the form to No.