Disable Design Changes for Tables Before Deploying Microsoft Access Databases
A feature in Microsoft Access 2013, 2010 and 2007 lets people easily modify the structure of a table without putting it into design mode. They can simply add a column while viewing the datasheet.
This makes it easy to change a table similar to the way people add columns to an Excel spreadsheet. However, this is not desirable if you created a database and deploy it to people who shouldn't be making structural changes to your tables.
Read this paper on the Allow Datasheet Schema feature to learn more about this feature and how to disable it for your users.
-
Disable the design functions for tables in Datasheet view. You opened the backstage view, clicked the Options navigation button, and clicked the Current Database tab. Inside the Access Options dialog, you unchecked the Enable design changes for tables in Datasheet view check box, clicked the OK button.
Regards,
Rachel Gomez
Please sign in to leave a comment.
Comments
1 comment