Forum home » Delegate support and help forum » Microsoft Access Training and help » Prevent record deletions default
Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Every time I create a new form I have to remember to alter the forms Allow Deletions property from Yes to No. I have been unable to find a default setting specifically for this property. It would be great to know if there is one since in the db concerned there must never be any deletions ever.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.
This converts the table into a system object, which cannot be viewed in the Database window.
You can show system objects in the Database window by the following:
Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
