Can I prevent users from opening an access 2003 database in design view? I don't want others to be able to change structure of the tables, just add change or delete the records within the table.
One thing you could pretty easily use to accomplish this is to use the
Here some links with details.
Another thing you can do that is easier then messing around with access permissions is to set the database properties to open a default form, and block design changes. When you enable these per-database features you will not be able to change the design of anything. Unless you disable it, you can bypass the design-only restriction and default form by holding down the left shift key when you open up the database.
See this link.
Why not just get those users a copy of the Microsoft Access Runtime which can access forms, table data and so on, but completely lacks all of the design features.
Typically this means your Office site installation could be cheaper as you only need full copies of Access for those who need it, rather than everybody.
|show 1 more comment|