I have a database with several forms, tables, queries etc. and it works fine. One of the users of the database accidentally deleted a record which was displayed by a query. I have selected AllowDelections = No in all object properties. Despite this, the record got deleted. Is there a way to prevent such deletions? Kindly help.
Way to prevent deletion of records?
- Thread starter gear
- Start date
boblarson
Smeghead
- Local time
- Today, 02:32
- Joined
- Jan 12, 2001
- Messages
- 32,059
You can only manage this via forms (the AllowDeletions = NO), if they open a query, or table, directly then there's no way to keep it from being deleted.
So, lesson here is, USE FORMS ONLY! If you want them to LOOK like queries, you can display the form in datasheet view.
So, lesson here is, USE FORMS ONLY! If you want them to LOOK like queries, you can display the form in datasheet view.
